今天爱分享给大家带来DQL语言-分组查询【三】,希望能够帮助到各位。
--统计每个部门有多少个人 select deptno as "部门",count(*) as "人数" from emp group by deptno;
原文链接:https://blog.itblood.com/118.html,转载请注明出处。
今天爱分享给大家带来DQL语言-分组查询【三】,希望能够帮助到各位。
--统计每个部门有多少个人 select deptno as "部门",count(*) as "人数" from emp group by deptno;