select a.sal from (select distinct(sal) from emp order by sal desc)a where

Find out the 3rd highest salary?

Question Posted / xyz

Answer Posted / xyz

select a.sal from (select distinct(sal) from emp order by
sal desc)a where rownum=3

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is a sql select statement?

1045

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1047

What is spool?

1062

What are different types of queries in sql?

1129

What is rownum?

990

What do you understand by case manipulation functions?

1047

How do you bind variables in pl sql?

1107

What is dense_rank in sql?

998

Explain how to use transactions efficiently : transact sql

990

How does pl sql work?

967

Explain exception handling in pl/sql?

1049

What is compiled query?

1045

How do you write a subquery?

1035

How to check if a column is nullable before setting to nullable?

1138

What are synonyms in sql?

983