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
30186 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

Why do we use cursors?

975

what is a table in a database ? : Sql dba

1024

What is application trigger?

976

How do I install sql?

974

Why do we use sql constraints?

1153

How to revise and re-run the last sql command?

1145

What is rank function in sql?

1000

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

What schema means?

876

how can we repair a mysql table? : Sql dba

956

What is the starting oracle error number?

1036

What does a pl/sql package consist of?

961

Which one is better subquery or joins?

1039

What is full join?

934

Explain how to use transactions efficiently : transact sql

955