select ename from table where sal in (select max(sal) from table

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

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

Answer Posted / purushotham

select ename from table where sal in
(select max(sal) from table_name
where deptno in ('10','20')
group by deptno);

Is This Answer Correct ?

16 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is gpt format?

943

What is insert command in sql?

1132

Which table is left in join?

983

Is stored procedure faster than query?

970

What is pragma in pl sql?

1116

which types of join is used in sql widely? : Sql dba

983

Are sql database names case sensitive?

1007

What is nvl?

1066

Is pl sql and postgresql same?

1138

what is data manipulation language? : Sql dba

1022

What is the location of pre_defined_functions.

1166

What is meant by cursor in sql?

1002

What is dialect in sql?

953

Can %notfound return null after a fetch?

1062

How can use stored procedures in sql?

1142