DISTINCT (table)

Returns a table by removing duplicate rows from another table or expression.

Syntax

DISTINCT(<table>)  

Parameters

Term	Definition
table	The table from which unique rows are to be returned. The table can also be an expression that results in a table.

Return value

A table containing only distinct rows.

Related functions

There is another version of the DISTINCT function, DISTINCT (column), that takes a column name as input parameter.

Example

The following query:

EVALUATE DISTINCT( { (1, "A"), (2, "B"), (1, "A") } )

Returns table:

[Value1]	[Value2]
1	A
2	B

Related content

Filter functions
DISTINCT (column)
FILTER function
RELATED function
VALUES function