DISTINCT
Selecting unique rows.
Note
Applying DISTINCT to calculated values is not currently implemented. For this purpose, use a subquery or the clause GROUP BY ... AS ....
Example
SELECT DISTINCT value -- only unique values from the table
FROM my_table;
The DISTINCT keyword can also be used to apply aggregate functions only to distinct values. For more information, see the documentation for GROUP BY.
Removes duplicate rows from the result. Applies after the clause GROUP BY ... AS ....
Was the article helpful?
Previous
Next