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

explain the difference between bool, tinyint and bit. : Sql dba

536

What are the set operators in sql?

566

Does google use sql?

526

How many sql core licenses do I need?

526

What is a variable in sql?

523

Can we call procedure in select statement?

532

What are the different type of joins in sql?

552

what is a trigger in mysql? : Sql dba

613

What are sql procedures?

590

What is package in pl sql with an examples?

555

Can you upgrade sql express to full sql?

525

what is error ora-03113: end-of-file on communication channel?

612

Explain constraints in sql?

579

Does sql profiler affect performance?

565

what is view? : Sql dba

566