select*from(select rownum rn,sal from(select*from emp order by sal desc))wh

Find out the 3rd highest salary?

Question Posted / kumar

Answer Posted / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2009

What is pessimistic concurrency control? : Transact sql

588

How to set up sql*plus output format in oracle?

596

How run sql*plus commands that are stored in a local file?

525

What is the use of double ampersand (&&) in sql queries? Give an example

613

What is crud diagram?

513

What is vector point function?

571

Is it possible to link two groups inside a cross products after the cross products group has been created?

597

How many sql statements are used?

570

What are pl/sql packages?

573

What is Collation Sensitivity ? What are the various type ?

501

what are rollup and cube in t-sql? : Transact sql

661

What is procedure and function in sql?

534

What is sql key?

525

Can two tables have same primary key?

531