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

12 Answers
19852 Views
IBM, Polaris, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How will you differentiate between varchar & varchar2?

991

What is the difference between a user and a schema in oracle?

982

Can you create a synonym without having a table?

977

what are the advantages of running a database in archive log mode?

2142

What is oracle datasource?

925

How to drop an index?

908

What is oracle join syntax?

942

Are truncate and delete commands same? If so why?

1079

How to convert characters to times in oracle?

954

Is oracle a programming language?

936

What is the difference between hot backup and cold backup in oracle?

956

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1948

Difference between hot backup vs. Cold backup?

945

How translate command is different from replace?

1005

What is procedure overloading in oracle?

992