how to find nth highest salary
Answer Posted / chandra sekhar
select min(salary) from emp where salary in (select top n salary from emp order by salary desc)
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Name the different type of indexes in sql?
Show Practically Sql Server Views are updatable?
what is memory-optimized nonclustered indexes
How can we delete a table in sql server?
What is normalization process?
What is the full form of dql?
What is cube dimension? : sql server analysis services, ssas
Explain about builtinadministrator?
Does index speed up select statements?
What is query processing?
What is abstracting periodical?
What is the cartesian product of table?
Explain features of analysis services?
How to invoke a trigger on demand?
How to add an address record into adventureworkslt?