select min(sal) from (Select rownum,sal FROM emp> Order by sal desc)

Find out the 3rd highest salary?

Question Posted / durgashivashankar

Answer Posted / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

604

What is hibernate and its relation to sql?

594

What are the three forms of normalization?

533

Which is faster count (*) or count 1?

542

What does over partition by mean in sql?

533

What is the use of partition by in sql?

517

What is the difference between python and sql?

524

What are the different ways to optimize a sql query?

488

what is the difference between a web-garden and a web-farm? : Sql dba

556

define join and explain different type of joins? : Sql dba

546

What is a pl/sql block?

595

Is primary key a clustered index?

537

Does sql profiler affect performance?

559

What are commit, rollback, and savepoint?

571

Is primary key always clustered index?

539