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

Does a primary key have to be a number?

971

What does count (*) do in sql?

1020

In a distributed database system, can we execute two queries simultaneously?

1100

Explain how can you save or place your msg in a table?

1037

How can you save or place your msg in a table?

1008

How can you know that statistics should be updated?

1086

describe mysql connection using mysql binary. : Sql dba

1074

What is auto increment?

1009

What is substitution variable?

1057

What is the difference between sql and t sql?

1048

How do I pipe the output of one isql to another?

1010

Enlist the data types that can be used in pl/sql?

1077

How to get help at the sql prompt?

1124

Is sql a backend?

1033

How would you reference column values before and after you have inserted and deleted triggers?

1071