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

Find out the 3rd highest salary?

Question Posted / arindam

Answer Posted / arindam

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

Is This Answer Correct ?

5 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is sql clause?

992

how to run 'mysql' commands from a batch file? : Sql dba

1060

Explain what is a subquery ?

1119

How to load data with sql*loader?

994

What will you get by the cursor attribute sql%found?

896

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1020

What are the key differences between SQL and PL SQL?

1146

What is the difference among union, minus and intersect?

949

What is difference between left and right outer join?

931

What is procedure in pl sql?

978

what are the advantages a stored procedure? : Sql dba

923

What is materialized view in sql?

870

What is %rowtype in pl sql?

922

What is pl sql variable?

934

What is dba in sql? : SQL DBA

994