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

Find out the 3rd highest salary?

Question Posted / shaiju nair

Answer Posted / shaiju nair

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

Is This Answer Correct ?

13 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What do you understand by pl/sql records?

535

When is the update_statistics command used?

574

What are reports usually used for?

568

How many aggregate functions are available there in sql?

528

Define commit, rollback and savepoint?

578

What is tuple in sql?

547

What is composite data type in pl sql?

559

Does sql view stored data?

536

What is sql engine in oracle?

524

What is sharding in sql?

566

What is cold data?

507

what are the t string functions available in tsql? : Transact sql

545

What is the difference between null value, zero, and blank space?

556

what is rdbms? : Sql dba

583

What are the two different parts of the pl/sql packages?

568