select max(sal) from emp where sal<(select max(sal) from emp where sal&l

how to check the 3rd max salary from an employee table?

Question Posted / amit

Answer Posted / amit

select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp));

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is ms sql traffic encrypted?

680

What is sql rowcount?

725

How do I delete a trigger?

721

What is difference between table and view?

704

How many joins in sql?

736

What is clustered and nonclustered index in sql?

693

Why stored procedure is better than query?

689

What does inner join mean?

754

What is trigger in sql and its types?

754

What do you understand by case manipulation functions?

728

how to delete an existing column in a table? : Sql dba

715

What does trigger mean in slang?

731

what is innodb? : Sql dba

760

Mention what is the use of function "module procedure" in pl/sql?

782

How to create an array in pl/sql?

770