| November 11, 2007 07:55:00 |
#2 |
| viswanadh kintali |
Member Since: Visitor Total Comments: N/A |
RE: Develop a mapping to extract the employee drawing ...
|
| I dont think this can by using a mapping. Following sql gives the dept number that gives maximum salary paid to all the employees put together. SELECT b
.deptno
FROM
(SELECT deptno,
SUM(salary) sal FROM emp GROUP BY deptno) b
WHERE
sal= (SELECT MAX(a.sal) sals
FROM (select deptno, sum (salary) sal
FROM emp GROUP BY deptno) a)
Let me know if this helped you.
visu |
| |
