blob: ae3eec3685635c26ac3eb4332d20d7ba4128dd61 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
# DISTINCT
Selecting unique rows.
{% note info %}
Applying `DISTINCT` to calculated values is not currently implemented. For this purpose, use a subquery or the clause [`GROUP BY ... AS ...`](../group_by.md).
{% endnote %}
## Example
```yql
SELECT DISTINCT value -- only unique values from the table
FROM my_table;
```
The `DISTINCT` keyword can also be used to apply [aggregate functions](../../builtins/aggregation.md) only to distinct values. For more information, see the documentation for [GROUP BY](../group_by.md).
|
