how to find nth highest salary
Answer Posted / suhail qaiser
SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC
| Is This Answer Correct ? | 38 Yes | 56 No |
Post New Answer View All Answers
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
when would you go for denormalization? : Sql server database administration
What are subquery and its properties?
What are the types of user defined functions in sql server?
Can two tables share the same primary key?
Tell me can we use custom code in ssrs?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is the new security features added in sql server 2016? : sql server security
difference between Clustered index and non clustered index ?
Is sql server is free?
Explain the microsoft sql server delete command?
Explain go command in sql server?
Can we use trigger new in before insert?
What is for xml in sql server?