distinct
The keyword distinct is used with the select/exec clause to eliminate
all the duplicate records and return distinct values.
The SQL keyword distinct supports distributed queries to access data
from DFS tables.
Note that the SQL keyword distinct differs from the distinct function in
that the latter does not guarantee the order of the returned elements, and renames the
columns in the result to "distinct_colName" by default.
As of the current version, distinct cannot be used with group
by, context by or pivot by.
Syntax
select distinct col1, col2, ... from table
Examples
t = table(`a`a`b`b`a`a`a`b as sym, 1 3 1 4 5 2 1 3 as id, 1..8 as value) select distinct id from t
| id |
|---|
| 1 |
| 3 |
| 4 |
| 5 |
| 2 |
select distinct id, sym from t
| id | sym |
|---|---|
| 1 | a |
| 3 | a |
| 1 | b |
| 4 | b |
| 5 | a |
| 2 | a |
| 3 | b |