Question

How do we use the DISTINCT statement? What is its use of DISTINCT statement?

Answer 1

The DISTINCT statement is used with the SELECT statement. If the record contains duplicate values then the DISTINCT statement is used to select different values among duplicate records.

Syntax:

SELECT DISTINCT column_name(s)

 FROM table_name;