SQL SELECT DISTINCT Statement [Eliminates Duplicate Rows]

How to Eliminates Duplicate Rows?

The “DISTINCT” returns only distinct value and DISTINCT “eliminates duplicate records” from the result set. Also “operates” only on a single column and not for multiple columns.

The “DISTINCT” key can be used with aggregates like COUNT, AVG, and MAX, so on..

Stayed Informed - 37 Best SQL Server Interview Questions and Answers

Syntax:-

SELECT DISTINCT ColumnName, ColumnName FROM TableName

               OR
-- USING COUNT AGGREGATE
SELECT COUNT (DISTINCT ColumnName) FROM TableName

Examples:-

SELECT DISTINCT CountryName 
 FROM Countries
ORDER BY CountryName

Result:-

CountryName CountryCode
---------------------------
India           IN
Nepal           NP
Rasia           RA
USA           US

Stayed Informed - SQL Server Query and Examples

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2