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 sql server agent and what are the two modes of authentication in sql server?
What is a trace frag? Where do we use it?
Explain the stored procedure?
What is store procedure?
Define Unique Key?
What are joins in sql and what are the different types of joins?
What are the new scripting capabilities of ssms? : sql server management studio
Why truncate is ddl command?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are the properties of the relational tables?
What does asynchronous call backs means?
What is ms sql server index?
What is resource db in sql server?
Which language rdl files made of?
What is the new security features added in sql server 2014? : sql server security