select * from tb
group by case when dt between '2007-10-1' and '2007-11-1' then 1
when dt between '2007-11-1' and '2007-12-1' then 2
--...
else 0 end
group by case when dt between '2007-10-1' and '2007-11-1' then 1
when dt between '2007-11-1' and '2007-12-1' then 2
--...
else 0 end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货