【单选题】在一般项目体检表generalitem(cno char(6),gtjrq date,gheight numeric(4,1),gweight numeric(4,1),gBMI numeric(3,1),gblood char(15),gsummary text,dno char(4))中,分组统计各个医生体检的人数,(注: cno 保健号,dno医生工号)并按人数降序排列出来。正确的SELEC...
A.
SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC
B.
SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
C.
SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) ASC
D.
SELECT DNO,SUM() as 人数 FROM generalitem GROUP BY dno ORDER BY COUNT(*) DESC