select empno from emp where (sal,deptno) in ( select max (sal),deptno fro

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 / rohan

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

Answer Posted / rohan

select empno from emp where (sal,deptno) in ( select max
(sal),deptno from emp where deptno in (10,20) group by
deptno)

Is This Answer Correct ?

13 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can I make sql query run faster?

1017

What is sql analyzer?

1025

What is 19 null in sql?

968

Is it possible to create the following trigger: before or after update trigger for each row?

1287

How do sql databases work?

1001

is mysql query is case sensitive? : Sql dba

1103

Explain commit, rollback and savepoint.

1002

What is indexing in sql and its types?

1080

what is the difference between nested subquery and correlated subquery?

1055

What is difference between pls_integer and integer?

964

Which join is like an inner join?

1027

Explain the components of sql?

1064

How many disk partitions should I have?

989

How do I use google cloud in sql?

1091

What is the example of procedure?

928