SELECT MONDAY,COUNT(*) from (select concat(concat(month(FBizdate),'-'),dayofmonth(FBizdate)) AS MONDAY FROM A
where fbizdate >= convert(datetime,'2013-08-1')
order by fbizdate ) GROUP BY MONDAY ORDER BY MONDAY
内外循环的顺序太不一致
怎么做才能 8-6 8-7 这么走下去?合并之后,日期的排序就是不照着这个来,求解释,谢谢!