1.9

DISTINCT Clause

DISTINCT Keyword

Table 7. DISTINCT Keyword

Keyword

Description

Order of Evaluation

DISTINCT

Eliminates duplicate rows

1

Example:

SELECT DISTINCT continent, name
FROM country
ORDER BY continent;

Results:

distinct.png

CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.