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

Which one is better sql or oracle?

927

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

953

Is primary key is clustered index?

967

What is int identity in sql?

1088

How run sql*plus commands that are stored in a local file?

1016

How do I run pl sql in sql developer?

1089

Can cursors be part of a trigger body?

1610

What is synonyms?

1019

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1012

What is normalization sql?

1016

Does a primary key have to be a number?

934

What is the use of non clustered index?

952

What is the file extension for sql database?

972

How do I remove sql plus from windows 10?

1054

What are different joins used in sql?

1029