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:[EMAIL PROTECTED] 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]
