SQL Tutorial : DRL / DQL - NON EQUI JOIN
Let's learn about next topic: NON EQUI JOIN
NON-EQUI JOIN:
*****************
- SELECT E.LAST_NAME,E.SALARY ,J.MIN_SALARY,J.MAX_SALARY
FROM EMPLOYEES E,JOBS J
WHERE E.SALARY BETWEEN J.MIN_SALARY
AND J.MAX_SALARY
- SELECT E.LAST_NAME,E.SALARY ,J.MIN_SALARY,J.MAX_SALARY
FROM EMPLOYEES E,JOBS J
WHERE E.JOB_ID=J.JOB_ID AND E.SALARY BETWEEN J.MIN_SALARY
AND J.MAX_SALARY
No comments:
Post a Comment