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:

distinct.png

This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/distinct_clause.