how to find nth highest salary
Answer Posted / yogesh
select e2.salary
from emp e1
join emp e2
on e1.salary >= e2.salary
group by e2.salary
having count(e2.salary) = n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What command do we use to rename a database?
What does indexation mean?
What is the difference between implicit and explicit transaction?
Do you know the different ddl commands in sql?
How to create a simple stored procedure in ms sql server?
Explain transaction isolation levels in sql server?
Which language is supported by sql server?
How do I find the sql server version?
How to sort query output in descending order in ms sql server?
How to provide default values to stored procedure parameters?
Explain relational data?
What do you mean by SQL injection attack?
What is the sql server agent?
Do comments need to go in a special place in sql server 2005?