how to check the 3rd max salary from an employee table?
- 23 Answers
- 32885 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 tuple in sql?
define sql delete statement ? : Sql dba
What are the types of index in sql?
what are local and global variables and their differences? : Sql dba
How to start oracle sql developer?
What is the use of sql trace?
How can we store rows in PL/SQL using array?
What packages(if any) has oracle provided for use by developers?
explain normalization concept? : Sql dba
How can we optimize a sql query?
How do I run a sql trace?
Should I use mbr or gpt?
What is the difference between nvl function, ifnull function, and isnull function?
What is procedure and function in sql?
Explain what is sql?
