how to check the 3rd max salary from an employee table?
- 23 Answers
- 30193 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
Explain dml and ddl?
What has stored procedures in sql?
What are the different types of joins in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What do you mean by field in sql?
What is field delimiter?
What is sql*plus?
What are the benefits of stored procedures?
what is sql? : Sql dba
How do I install sql?
How do I view tables in mysql?
What is the advantage of index in sql?
what is a database lock ? : Sql dba
How is a PL/SQL code compiled?
Can we use insert statement in function?
