How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to enforce security in sql server? : sql server security
how can a database be repaired? : Sql server administration
How to restore performance issues and how to check?
What is the default sql server instance name?
Where views are stored in sql server?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Differentiate between truncate vs delete in mssql?
Ms sql server index?
What command do we use to rename a database?
What is self contained scalar sub query?
What are the limitations/drawbacks or ssrs 2008 r2?
What is difference in performance between insert top (n) into table and using top with insert?
What is report snapshot?
What is the impact on other user sessions when creating indexes?
What are the recovery models for a database?