Explain DISTINCT clause in SQL ?

The DISTINCT clause allows you to remove duplicates from the result set.

 

Syntax:

 

SELECT DISTINCT column(n) FROM table_name WHERE [condition]

ORDER BY column;