How to select unique elements in a column of the table in DolphinDB?

Viewed 22

If there are duplicated elements in a column, how to select the unique elements in a column in DolphinDB?

1 Answers

The function distinct is used to remove the duplicated elements.

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

Result:

enter image description here

Related