select min(sal) from (select sal from (select distinct(sal) from emp orde

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

Question Posted / arjun

Answer Posted / arjun

select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a procedure and a function?

696

what is the use of friend function? : Sql dba

725

What is Materialized View? In What Scenario we Use Materialized View?

8935

How bulk collect improves performance?

741

What is data profiling in sql?

735

What is a parameter query?

817

What are two statement types in sql?

740

Is drop table faster than truncate?

738

what are the drivers in mysql? : Sql dba

730

Why is the cursor important?

729

What are the two types of periodical indexes?

658

What is schema in sql example?

824

Is sql better than access?

710

What is the use of index in hive?

726

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

932