distinct

distinct(X)

X is a vector.

Return the distinct elements from vector X. The order of the elements in the result is not guaranteed.

distinct 4 5 5 2 3;
// output: [3,2,5,4]

t=table(3 1 2 2 3 as x);
select distinct x from t;

select sort(distinct(x)) as x from t;

The function distinct returns a vector, while the function set returns a set.

x=set(4 5 5 2 3);
x;
// output: set(3,2,5,4)

x.intersection(set(2 5));
// output: set(2,5)