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