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
What is ms sql server index?
What is the meaning of resultset type_scroll_insensitive?
What are the five characteristics of good data?
Can you leave a union at any time?
What happens if ntwdblib.dll is missing on your machine?
How do clustered indexes store data?
Does group by sort data?
What is row-level compre?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain primary key in sql server?
Is INSTEAD OF trigger directly applicable to Table ?
Do you know what are different types of replication in sql server?
Describe in brief sql server monitoring ways.
what are the new features introduced in sql server 2000? : Sql server database administration
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.