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:
End-of-Chapter Survey
: How would you rate the overall quality of this chapter?- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality