在一般项目体检表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))中,分组统计2018年上半年各个医生体检的人数,
A.
SELECT dno, count(*) as 人数 FROM generalitem WHERE gtjrq>=’2018-01-01’ and gtjrq
B.
SELECT dno,sum() as 人数 FROM generalitem WHERE between '2018-01-01' and '2018-06-30' GROUP BY dno
C.
SELECT dno,count(*) as 人数 FROM generalitem GROUP BY dno where gtjrq>=’2018-01-01’ and gtjrq
D.
SELECT DNO,COUNT(*) as 人数 FROM generalitem GROUP BY dno where between '2018-01-01' and '2018-06-30'