DISTINCT
DISTINCT eliminates duplicate rows from the result set.
Syntax
DISTINCT columnX
Remarks
• If any column has a NULL value, it is treated like any other value.
• If you have DISTINCT and GROUP BY in the SELECT clause, the GROUP BY is applied first before DISTINCT.
• DISTINCT supports all data types, including: BLOB, CLOB, and XML.
• DISTINCT in the SELECT clause and DISTINCT in an aggregate function do not return the same result.
Example
SELECT DISTINCT StateOrProvince
FROM /shared/examples/ds_orders/customers customers