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

Category: SQLHow do we use the DISTINCT statement? What is its use?
Editor">Editor Staff asked 2 years ago

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

1 Answers
Editor">Editor Staff answered 2 years ago

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;