select sum(a),day([date]) from record where year([date]) = '2010' group by day([date]) select sum(a),datename(week,[date]) from record where year([date]) = '2010' group by datename(week,[date]) select sum(a),month([date]) from record where year([date]) = '2010' group by month([date])
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货