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

How many scalar data types are supported in pl/sql?

1058

What is index example?

1013

Sql technical questions

1284

How can check sql version from command line?

1089

How do you get column names only for a table (sql server)?

1170

What is a sql statement?

969

How many commands are there in sql?

1032

Is sql a dbms?

1017

What is sap sql anywhere?

1084

Why do we use triggers?

972

What do you think about pl/sql?

1039

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1116

What is prepared statement in sql?

1056

What kind of join is join?

975

What packages(if any) has oracle provided for use by developers?

5811