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
30174 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 many joins can you have in sql?

918

How exception is different from error?

1002

What is primary key secondary key alternate key candidate key?

1015

List out the acid properties and explain?

939

What is full form of rtm?

989

What is pls_integer in pl sql?

1072

How do I partition a table in sql?

1102

What is count * in sql?

979

What is java sql driver?

1091

Why commit is not used in triggers?

1023

Does inner join remove duplicates?

930

The select into statement is most often used to create backup copies of tables or for archiving records?

1055

What do you mean by stored procedures?

995

Is not null in sql?

966

Can I learn sql in a week?

1043