WITH Clause Queries

SELECT E.ENAME,E.DEPTNO , DC.EMP_COUNT

FROM EMP  E ,

( SELECT DEPTNO,COUNT(*) AS EMP_COUNT FROM EMP GROUP BY DEPTNO) DC

WHERE E.DEPTNO = DC.DEPTNO

/

WITH EMP_COUNT AS (

SELECT DEPTNO,COUNT(*) AS EMP_COUNT FROM EMP GROUP BY DEPTNO

)

SELECT E.ENAME , EC.EMP_COUNT

FROM EMP E, EMP_COUNT EC

WHERE E.DEPTNO = EC.DEPTNO