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

What are some emotional triggers?

930

What is difference between db2 and sql?

940

Is join an inner join?

898

Is natural join and inner join same?

854

How do I truncate a sql log file?

1007

Does pl sql work in mysql?

923

What is sql scripting?

1037

What is a rank in sql?

901

How does postgresql compare to mysql?

989

Can there be more than one function with a similar name in a pl/sql block?

927

What is sql engine in oracle?

930

Whis is not false in primary key?

1406

How do I run a sql trace?

908

When is the update_statistics command used?

1049

What is the difference between left join and right join?

889