Use of DISTINCT clause

 Subscribe in a reader

 

In table, some of the columns may contain duplicate values. Sometimes you will want to list only the different (distinct) values in a table.

 

The DISTINCT clause allows removing duplicates from the result set. and this clause can only be used with select statement.

 

 

SELECT DISTINCT ColumnName1,ColumnName2 FROM TableName;

 

OR

SELECT DISTINCT * FROM TableName;

 

EXAMPLE

SELECT DISTINCT * FROM Employee;