可以在視圖中現!
select id,name,year(date),month(date),sum(chidao),sum(qing) from main
group by id,name,year(date),month(date)
select id,name,year(date),month(date),sum(chidao),sum(qing) from main
group by id,name,year(date),month(date)
select name,convert(char(4),datepart(year,date)) as fyear,convert(char(2),datepart(month,date)) as fmonth,sum(chidao) as fchidao,sum(qing) as fqing
from main
group by name,fyear,fmonth
select id,name,year(date),month(date),sum(chidao),sum(qing) from main
group by id,name,year(date),month(date)
并没有难点啊!你实行时 出错了吗?
create view aaa as
select name,convert(char(4),datepart(year,date)) as fyear,convert(char(2),datepart(month,date)) as fmonth,sum(chidao) as fchidao,sum(qing) as fqing
from main
group by name,convert(char(4),datepart(year,date)) ,(char(2),datepart(month,date))