Saya mencoba dengan cara yang lain tapi hasilnya sama. Mudah2an membantu
select a.DNAME,count(b.ENAME) jml_emp,NVL(TO_CHAR(AVG(b.sal), '99999.99'), 'No average') avg_sal,nama,c.sal,c.job from dept a,emp b,(select deptno,ename nama,sal,job from emp)c where a.DEPTNO = b.DEPTNO(+) and a.DEPTNO = c.DEPTNO(+) group by a.DNAME,nama,c.sal,c.job order by a.dname ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of wawan mulyawan Sent: 28 Februari 2007 11:43 To: [email protected] Subject: RE: [indo-oracle] Tolong dunk... Kalau di liat dari querynya ini , sepertinya mau membandingkan salary dari seseorang dengan rata rata salary di departemen yang bersangkutan Makanya harus ada 2 employes , satu untuk orang yang dibandingkan satu untuk menghitung rata-rata salary di departemen itu. Semoga membantu Ti Mulyawan -----Original Message----- From: [email protected] <mailto:indo-oracle%40yahoogroups.com> [mailto:[email protected] <mailto:indo-oracle%40yahoogroups.com> ] On Behalf Of bapux oke Sent: Wednesday, February 28, 2007 11:08 AM To: Indo Oracle Subject: [indo-oracle] Tolong dunk... Dear all, Saya punya query seperti ini, SELECT d.department_id, d.department_name, count(e1.employee_id) employees, NVL(TO_CHAR(AVG(e1.salary), '99999.99'), 'No average') avg_sal, e2.last_name, e2.salary, e2.job_id FROM department d, employees e1, employees e2 WHERE d.department_id = e1.department_id(+) AND d.department_id = e2.department_id(+) GROUP BY d.department_id, d.department_name, e2.last_name, e2.job_id Nah yang aku ngga ngerti kenapa harus ada 2 employees, kenapa ngga langsung aja ? Mohon penjelasannya ya, thanx before. Hendra --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
