 |
| Total Answers and Comments: 3 |
Last Update: June 06, 2009 Asked by: c.p.mohan |
|
| | |
|
Submitted by: arun_doss
SELECT empno, sal, ( SELECT SUM ( a.sal )
FROM emp a ) total_sal
FROM emp;
Above answer was rated as good by the following members:
hetal_gor | |
June 05, 2009 08:41:53 | #3 |
| sumanta.bala |
|
Member Since: June 2009 Contribution: 2 |
RE: How to compare the total salary of all employee with a individual employee salary for a particular department.
| SELECT ename deptno sal TRUNC (AVG (sal) OVER (PARTITION BY deptno)) avg_sal FROM scott.emp
| | | Is this answer useful? Yes | No | | |
|
| |
Go To Top
|
1 
0