Distinct Clause in SQL

by Shikha Katariya · August 18, 2015

Distinct Clause in SQL is used to fetch only unique values and remove the duplicate values from the result.

The changes made by Distinct Clause are not permanent and are not written on disk.These changes are temporarily done in buffer.

Distinct Clause is used in SELECT Statement.

Distinct Clause can be applied to single column or combination of columns.

Distinct Clause for a single column :

SELECT DISTINCT(<Col>) FROM <Tablename>;

Brackets are optional.

Distinct Clause when applied to a single column fetc

Distinct Clause for a multiple columns :

SELECT DISTINCT <Col 1> , <Col 2 >….<Col n> FROM <Tablename>;