Select Ename From emp where sal in (Select Max(Sal) From emp where deptno

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

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

Answer Posted / lipika

Select Ename From emp where sal in (Select Max(Sal) From
emp where deptno in (10,20) group by deptno);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

992

how to get a list of columns in an existing table? : Sql dba

1001

Can we use threading in pl/sql?

1089

What are the uses of sysdate and user keywords?

1148

What is not in sql?

997

What is oracle sql developer?

1118

How do you know if a relationship is 2nf?

993

how to use like conditions? : Sql dba

1162

Is natural join and inner join same?

991

explain normalization concept? : Sql dba

1086

What are field types?

1051

What is the usage of sql functions?

1199

What are the advantages of pl sql over sql?

1071

What are tuples in sql?

1197

Does truncate need commit?

1001