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

Is sql better than access?

1067

What is a sql select statement?

1082

Can a foreign key be null?

1142

What is the example of procedure?

977

Explain dml and ddl?

1056

Enlist the characteristics of pl/sql?

1844

What are different categories of sql commands?

1194

How to add, remove, modify users using sql?

1089

What is cte sql?

1052

How to set up sql*plus output format in oracle?

1081

What is the sql query to display the current date?

1092

What are the main features of cursor?

1108

Can we delete column in sql?

1172

How do I count rows in sql query?

1039

What is union?

1250