select department 部门,id 工号,name 姓名,sum(money) 金额
from 表
where month(date)=4
group by department,id,name
select id, name , count(money) from 表名 where MONTH(date) ='2' group by id ;
select department,id,name,sum(money) from 表名 where dd>=#2013-4-01# and dd<#2013-5-01# group by department,id,name
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024