3rd highest salary in sql server

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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
http://www.code-sample.com
http://www.code-sample.xyz

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.