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: 523

Filed under:
|
|

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;

alt text

How can i only show the employees that have a salary within 10% of their manager salary?

© Stack Overflow or respective owner

Related posts about percentage

Related posts about sql