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 the difference between ereg_replace() and eregi_replace()? : Sql dba

558

Explain lock escalation? : Transact sql

708

Does postgresql run on the cloud?

593

What are the two types of exceptions in pl/sql?

548

What is a loop in sql?

572

Is record in oracle pl sql?

535

How do you optimize a query?

540

what is sp_pkeys? : Transact sql

702

what are the different tables present in mysql? : Sql dba

506

What is the difference between mdf and ndf files?

573

How do you write a subquery?

526

what is column? : Sql dba

576

How do you update sql?

523

What does (*) mean in sql?

527

Is left join same as inner join?

543