Asp.Net & Interview Questions
This Blog Lists Asp.Net C# Programs and Interview Questions of different technologies.
Pages
Home
Asp.net Project List
Seminar List
Interview Tips
Common Interview Questions
C# Coding Standards
Friday, 31 October 2014
Get Third Highest Salary Sql Query
Get Third Highest Salary
SELECT TOP (1) * FROM
(SELECT TOP (3) Empsalary FROM employeeMaster ORDER BY empsalary DESC) T
ORDER BY empsalary ASC
No comments:
Post a Comment
Thanks
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
SQL server tricky questions
No comments:
Post a Comment
Thanks