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