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

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

What is vector point function?

1027

How do I view stored procedures?

958

What are the different types of tables in sql?

975

what are properties of a transaction? : Sql dba

1077

What are the most important ddl statements in sql?

1088

How many sectors are in a partition?

1062

What are the types of index in sql?

1050

how to analyze tables with 'mysqlcheck'? : Sql dba

996

Why use subqueries instead of joins?

1066

What do you mean by “trigger” in sql?

1055

Differentiate between % rowtype and type record.

1278

How many clustered indexes can you have?

950

What happens when a trigger is associated to a view?

897

What is a parameter query?

1059