Description
The SQL DISTINCT clause is used to remove duplicates from the result set of a SELECT statement.Note
· When only one expression is provided in the DISTINCT clause, the query will return the unique values for that expression.
· When more than one expression is provided in the DISTINCT clause, the query will retrieve unique combinations for the expressions listed.
· In SQL, the DISTINCT clause doesn't ignore NULL values. So when using the DISTINCT clause in your SQL statement, your result set will include NULL as a distinct value.
=========================================================================
SELECT DISTINCT salary, description
FROM employee1
ORDER BY description,salary
FROM employee1
ORDER BY description,salary
