【单选题】
A select rankid 部门编号,sum(*) 员工总数 from emp group by rankid order by 员工总数
B select rankid 部门编号,count(*) 员工总数 from emp order by rankid order by 员工总数
C select rankid 部门编号,count(*) 员工总数 from emp group by rankid order by 员工总数
D select rankid 部门编号,count(*) 员工总数 from emp order by rankid group by 员工总数
查看更多
