select * from ( select * from (select * from emp order by sal desc) whe

Find out the 3rd highest salary?

Question Posted / sachin

Answer Posted / sachin

select * from ( select * from (select * from emp order by
sal desc)
where rownum<=3
order by rownum desc)
where rownum=1

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is clustered index sql?

985

Why primary key is required?

1007

What are the different datatypes available in PL/SQL?

1085

How do we accept inputs from user during runtime?

1065

Why use triggers in sql?

957

Explain isolation levels. : Transact sql

1072

What is cascade in sql?

964

How to write pl sql program in mysql command prompt?

1100

What is number function in sql?

976

Why commit is not used in triggers?

1040

what is a composite key ? : Sql dba

1063

Explain alias in sql?

1051

what is the stuff function and how does it differ from the replace function? : Sql dba

1058

Is a view faster than a stored procedure?

970

Is sql free?

970