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

How many primary keys can a table have?

534

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

521

What is the main reason behind using an index?

556

What sql does db2 use?

544

How to download oracle sql developer?

665

What is the syntax and use of the coalesce function?

601

What does select top 1 do in sql?

544

What is data modelling in sql?

523

Explain the difference between drop and truncate commands in sql?

534

What is a constraint?

567

How many times can we commit in a loop?

566

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

531

What is a Mapplet?

645

What are conditional predicates?

587

How to run sql statements with oracle sql developer?

625