SELECT A.EMP_NAME, SUM(B.MAX_SALARY) AS MAX_SAL, B.EMP_DEPT_NO FROM EMP

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 / vishnu prasad.ma

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

Answer Posted / vishnu prasad.ma

SELECT A.EMP_NAME, SUM(B.MAX_SALARY) AS MAX_SAL, B.EMP_DEPT_NO FROM EMP_DETAILS A,
(SELECT MAX(EMP_SAL) AS MAX_SALARY, EMP_DEPT_NO FROM EMP_DETAILS WHERE EMP_DEPT_NO IN (10,20)
GROUP BY EMP_DEPT_NO) B
WHERE
A.EMP_SAL = B.MAX_SALARY
AND A.EMP_DEPT_NO = B.EMP_DEPT_NO
GROUP BY A.EMP_NAME, B.EMP_DEPT_NO

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to display the current date in sql?

1084

What is the current version of postgresql?

1070

What is inner join in sql?

1087

explain the difference between delete , truncate and drop commands? : Sql dba

1098

What is normalisation in sql?

1066

What is set serveroutput on?

1140

what is the difference between char and varchar data types? : Sql dba

1127

What is a common use of group by in sql?

1051

Is primary key an index?

998

How do you modify a trigger?

930

What are different types of sql?

1196

How can I change database name in sql?

1088

How many sql statements are used? Define them.

1045

What is range partitioning?

973

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1835