how to find nth highest salary
Answer Posted / amarjit singh
--display 3rd higest salary in MSSQLSERVER
select max(sal) from emp
where sal <(select max(sal) from emp
where sal <(select max(sal) from emp
))
--By , STUDENT OF IET BHADDAL ENG COLLEGE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute the cursor queries with "open" statements?
What is raiseerror? What is raiseerror?
How to disable stored procedure sql server?
How to execute stored procedure and set temp table in sql server?
What is the maximum size of a dimension? : sql server analysis services, ssas
What is the contrast between sql and pl/sql?
What is merge join?
Why do we use functions?
Does table partitioning improve performance?
What are the instances when triggers are appropriate?
What are the requirements for sql server 2016?
What is the Difference Between Primary and Foreign Key?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is Command line parameters in PLSQL.?
What is the boxing and unboxing concept in .net?