SELECT COUNT(*), FIRST_NAME
FROM EMPLOYEES E, DEPARTMENTS D
WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
GROUP BY FIRST_NAME
HAVING COUNT(*) > 0
AND SALARY > 1000
OR LAST_NAME IS NOT NULL ;
martes, 8 de noviembre de 2016
JOIN SIN LA CLAUSULA JOIN
Ademas de los JOINS que utilizan esta misma clausula, tenemos los ejemplos siguientes de JOINS.
SELECT COUNT(*), FIRST_NAME
FROM EMPLOYEES E, DEPARTMENTS D
WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
GROUP BY FIRST_NAME
HAVING COUNT(*) > 0
AND SALARY > 1000
OR LAST_NAME IS NOT NULL ;
SELECT COUNT(*), FIRST_NAME
FROM EMPLOYEES E, DEPARTMENTS D
WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
GROUP BY FIRST_NAME
HAVING COUNT(*) > 0
AND SALARY > 1000
OR LAST_NAME IS NOT NULL ;
0 comentarios:
Publicar un comentario