sql查询

SELECT e.ename,d.dname,z.count(*)
FROM emp e INNER JOIN dept d ON e.deptno=d.deptno
INNER JOIN (SELECT deptno,COUNT(*) FROM emp GROUP BY deptno)z ON z.deptno=d.deptno

---

作者：空城1995
来源：优快云
原文：https://blog.youkuaiyun.com/fy_java1995/article/details/80305172
版权声明：本文为博主原创文章，转载请附上博文链接！