摘要:
Select Season = Case when month(日期) in (1,2,3) then '一季度' whenmonth(日期) in (4,5,6) then '二季度' whenmonth(日期) in (7,8,9) then '三季度' whenmonth(日期) in (10,11,12) then '四季度' end,count(*) fromtablenamegroup by Case when month(日期) in (1,2,3) then '一季度' whenmonth(日期) 阅读全文