how to check the 3rd max salary from an employee table?
- 23 Answers
- 30270 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / b.v.siva kumar
Use this for SQL Server:
select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is bulk collect in pl sql?
Why do we use procedures in pl sql?
What is a null value?
What is anonymous block in sql?
What are commit, rollback, and savepoint?
How to know the last executed procedure?
What is meant by user defined function?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the sql case statement?
What is recursive join in sql?
what are the different type of sql's statements ? : Sql dba
Does sql require a server?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is the purpose of design view?
What is break?
