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
How you can change the database name in SQL SERVER?
What do you understand by SQL*Net?
Describe how to use the linked server?
Is oracle faster than sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to find which stored procedure is currently running in sql server?
What is the recommended total size of your memory optimized tables?
Give me a SQL Query to find out the second largest company?
What is transaction server isolation?
What is the use of toad or sqldbx.?
What is replication with database mirroring? : sql server database administration
What are the approximate numeric data types?
How many types of stored procedures are there in sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is extended stored procedures?