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

How to handle a single quote in oracle sql?

1053

How to use in conditions in oracle?

1058

Is insert autocommit in oracle?

1068

How to create a new oracle data file?

1032

Whats the benefit of dbms_stats over analyze?

2002

How to drop a tablespace?

1043

Can we call procedure inside function in oracle?

1093

why dont we assign not null constraint as table level constraint.

2738

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2108

Explain the use of ignore option in imp command.

1035

How to run queries on external tables?

1047

How can I create database in oracle?

1026

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

What is the difference between pre-select and pre-query?

1219

How to change user password in oracle?

1029