What is DISTINCT statement in SQL server? What is its use?

Question

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;