1.10 Eliminating duplication in retrieval results (SELECT DISTINCT)

Use SELECT DISTINCT to eliminate duplication in retrieval results. The specification format of SELECT DISTINCT is as follows.

Specification format

SELECT DISTINCT "column-name" FROM "table-name"
    WHERE search-condition

DISTINCT:

Specify this if you want to eliminate duplication in retrieval results.

Note

For details about the syntax of SELECT DISTINCT, see 7.2.1 Specification format and rules for query specifications.

Organization of this section

• 1.10.1 Example: Retrieve customers who purchased products

To Page Top