how to find nth highest salary
Answer Posted / dinesh
select distinct(a.salary)
from Salarydtls a
where 3= (select distinct(count(b.salary))
from salarydtls b
where a.salary<=b.salary)
ans is for third highest sal
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain system scalar functions?
What are commit and rollback in sql?
Explain the microsoft sql server delete command? : SQL Server Architecture
When would you use sql joins?
What stored by the model? : sql server database administration
What is left outer join in sql server joins?
What is a linked server in sql server?
Does the order of columns in update statements matter?
What is cube dimension? : sql server analysis services, ssas
What is the command used to check locks in microsoft sql server?
In which tcp/ip port does sql server run? Can it be changed?
What is subquery explain with example?
What do you mean by tablesample?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to configure odbc dsn with different port numbers?