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 are the various restrictions imposed on view in terms of dml?

531

Is sqlite thread safe?

615

How can use stored procedures in sql?

595

Is null operator in sql?

617

what is a stored procedure? : Sql dba

569

What is trigger in pl sql with examples?

529

Cite the differences between execution of triggers and stored procedures?

632

What is compiled query?

531

What is indexing oracle sql?

568

Can a procedure in a package be overloaded?

556

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

518

How do I order columns in sql?

537

what are the properties and different types of sub-queries? : Sql dba

516

how to convert character strings to numeric values? : Sql dba

590

what is the difference between a local and a global temporary table? : Sql dba

562