WITH dept_count AS ( SELECT department_id, COUNT(*) AS dept_count FROM emp GROUP BY department_id) SELECT e.first_name,e.last_name AS ...
確定! 回上一頁