select max(sal) from emp having max(sal)!=(select max(sal) from emp where

a query to select maxmun 3 salaries of employee table

Question Posted / neo devan

Answer Posted / neo devan

select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between substr and instr?

511

Explain the use of constraints option in exp command.

552

can u plz provide me oca sql dumps please i need them

1460

What is the exact use of Collections?

1672

What is a sub query? What are its various types?

575

Is there an oracle sql query that aggregates multiple rows into one row?

539

What is not equal to in oracle?

518

How do we create privileges in oracle?

580

How to assign query results to variables?

584

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1787

How to lock and unlock a user account in oracle?

607

How to use attributes of the implicit cursor in oracle?

554

What is backup in Oracle?

563

What are the limitations oracle database 10g xe?

565

What is a synonym? What are its various types?

617