select ename,sal from emp where sal in (select max(sal) from emp group by

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

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

Answer Posted / gautam

select ename,sal from emp
where sal in (select max(sal) from emp group by deptno)
and deptno in (10,20)

Gautam

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rename in sql?

1019

What is sqlerrd?

1016

State few characteristics of pl/sql?

1025

What is dbo in sql?

1019

How are sql commands classified?

1143

What are data types in pl sql?

1199

What is the use of prepared statement?

1076

Which one is faster ienumerable or iqueryable?

991

How many sql are there?

1053

What is Materialized View? In What Scenario we Use Materialized View?

9621

describe mysql connection using mysql binary. : Sql dba

1123

what are all different types of collation sensitivity? : Sql dba

1030

What is package in pl sql?

1086

how to load data files into tables with 'mysqlimport'? : Sql dba

1148

How many subqueries can be nested in a statement?

1042