Explain DISTINCT clause in SQL Server.

The DISTINCT clause is normally used with SQL SELECT statement to get unique dataset entries from a database table.

Ex :
Select distinct EmployeeName
from Employees

This Query will display only the unique Employee Names from the Employees table.