Calculate Percentage help ORACLE L@@K
Posted
by DAVID
on Stack Overflow
See other posts from Stack Overflow
or by DAVID
Published on 2010-04-27T00:19:02Z
Indexed on
2010/04/27
0:23 UTC
Read the original article
Hit count: 556
Hi this code gives me employee salaries and manager salaries.
SELECT E.EMP_FNAME AS MANAGER, E.EMP_SALARY, D.DEPT_NO, A.EMP_FNAME AS EMPLOYEE, A.EMP_SALARY
FROM EMPLOYEE E, EMPLOYEE A, DEPARTMENT D
WHERE E.EMP_NIN = A.EMP_MANAGER
AND A.EMP_MANAGER = D.EMP_MANAGER;
How can i only show the employees that have a salary within 10% of their manager salary?
© Stack Overflow or respective owner