sub query
-
SQL - JOIN, SUB QUERY, INLINE TABLE, IN VIEWDB/SQL 2018. 8. 3. 16:36
SELECT *FROM EMPLOYEESWHERE DEPARTMENT_ID IN ( SELECT DEPARTMENT_ID FROM EMPLOYEES WHERE FIRST_NAME = 'Steven' )AND FIRST_NAME != 'Steven' -- 여러개일때는 IN 사용; SELECT E.EMPLOYEE_ID, E.FIRST_NAME, E.LAST_NAME, E.SALARY, D.DEPARTMENT_NAMEFROM EMPLOYEES E, DEPARTMENTS DWHERE SALARY > ( SELECT ROUND( AVG(SALARY), 0 ) FROM EMPLOYEES )ORDER BY SALARY; SELECT E.*FROM DEPARTMENTS D , LOCATIONS L , EMPLOYEES..