SQL Server Transact Basic to Expert - Select Query with Distinct

This blog show how to use the distinct keyword with the Select query. Distinct is used to get the unique values of a column in a table.

Syntax:

Select Distinct(ColumnName)
From table
Where Condition

Example:

Select Distinct(EmpName)
From Emptable
Where Empsal > 1000