select * from (select ename, deptno,sal from emp where deptno in(10 , 20)

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / sonal

24 Answers
29875 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / sonal

select * from (select ename, deptno,sal
from emp where deptno in(10 , 20)
order by sal desc)
where rownum < =1

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between the conventional and direct path loads? : aql loader

1351

Is id a reserved word in sql?

1119

What is cascade in sql?

933

how do you know the version of your mysql server? : Sql dba

963

how to get a list of all tables in a database? : Sql dba

940

How long will it take to learn pl sql?

912

Which one is faster ienumerable or iqueryable?

889

Explain isolation levels. : Transact sql

1028

What is trigger types in sql?

966

What are the benefits of pl sql?

1084

Is crud a cuss word?

991

What is having clause in sql?

941

What can sql server reporting services do?

1082

What is case function?

1004

Where is pl sql used?

926