select dept_id,ename max(sal) from employee where dept

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

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

Answer Posted / john

select dept_id,ename max(sal) from employee where dept_id
in ('1','2') group by dept_id;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does where 1/2 mean in sql?

1084

Can we rollback truncate?

1001

How many sql commands are there?

1118

what are the advantages of sql ? : Sql dba

1060

What is a memo field?

970

define sql insert statement ? : Sql dba

1033

how to shutdown mysql server? : Sql dba

1107

Why do we need sharding?

998

How do I view a procedure in sql?

978

how to concatenate two character strings? : Sql dba

1103

what are the type of locks ? : Sql dba

966

What is sqlca in powerbuilder?

1023

Which is better join or subquery?

1141

Can a composite key be null?

981

Explain correlated query work?

1059