数据库简单语法练习

select deptno as 部门,count(*) as 人数
from emp group by deptno;  
 

posted @ 2017-07-14 17:29  妤轩  阅读(146)  评论(0)    收藏  举报