Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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!!

Share the post

SQL SELECT DISTINCT Statement [Eliminates Duplicate Rows]

×

Subscribe to Angular 2 Javascript Asp.net C# Sql Server Knockoutjs Angularjs Kendo Ui Html 5 Web Api Wpf Wcf Etc.

Get updates delivered right to your inbox!

Thank you for your subscription

×