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

Describe sql comments?

1111

Is sql low level language?

1065

how can we know the count/number of elements of an array? : Sql dba

1107

what is the syntax used for partition in tsql? : Transact sql

1060

Which is faster count (*) or count 1?

1088

Can we rename a column in the output of sql query?

1039

Explain polymorphism in pl/sql.

1171

How do you update sql?

1036

How do you exit in sql?

1158

Is there a way to automate sql execution from the command-line, batch job or shell script?

1016

What is sql and how does it work?

1248

How do I install microsoft sql?

1116

Name the different types of indexes in sql and define them.

1222

Explain what is sql?

1180

what is “go” in t-sql? : Transact sql

1155