1.9
DISTINCT Clause
DISTINCT Keyword
- The DISTINCT clause removes duplicate rows from a query.
- DISTINCT appears directly after the SELECT clause.
- You can specify multiple columns, which means that the combination of columns must be unique.
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:
