행위

"Oracle CROSS APPLY Join"의 두 판 사이의 차이

DB CAFE

(새 문서: <source lang=sql> SELECT department_name, employee_id, employee_name FROM departments d CROSS APPLY (SELECT employee_id, employee_name FROM employees e...)
(차이 없음)

2019년 8월 5일 (월) 22:01 판

thumb_up 추천메뉴 바로가기


SELECT department_name, employee_id, employee_name
FROM   departments d
       CROSS APPLY (SELECT employee_id, employee_name
                    FROM   employees e
                    WHERE  salary >= 2000
                    AND    e.department_id = d.department_id)
ORDER BY 1, 2, 3;