select deptno,groupno,sum(initam) as sumin,sum(importamt) as sumim
from dayreport
where datefield between '2002-12-1' and '2003-1-1'
grouy by deptno,groupno
from dayreport
where datefield between '2002-12-1' and '2003-1-1'
grouy by deptno,groupno
祝贺你有进步了!