首先,要确定你的字段类型,是字符型还是日期型!以下是当你的字段类型为日期型的:
select year(datefield) as years,sum(numfield)
from tablename
where datefield >= @Dt1
and datefield < @Dt2
group by year(datefield)
select year(datefield) as years,sum(numfield)
from tablename
where datefield >= @Dt1
and datefield < @Dt2
group by year(datefield)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货