按年汇总 year(日期)
按月汇总 month(日期)+'-'+year(日期)
按季度汇总 case when month(日期) in(1,2,3) then 1+'-'+year(日期)
            when month(日期) in(4,5,6) then 2+'-'+year(日期)
            when month(日期) in(7,8,9) then 3+'-'+year(日期)
            when month(日期) in(10,11,12) then 4+'-'+year(日期)
            end
别的自己写了

纠正
按年汇总 year(日期)
按月汇总 convert(varchar(2)+month(日期))+'-'+convert(varchar(4),year(日期))
按季度汇总 case when month(getdate()) in(1,2,3) then convert(char(1),1)+'-'+convert(varchar(4),year(getdate()))
            when month(getdate()) in(4,5,6) then convert(char(1),2)+'-'+convert(varchar(4),year(getdate()))
            when month(getdate()) in(7,8,9) then convert(char(1),3)+'-'+convert(varchar(4),year(getdate()))
            when month(getdate()) in(10,11,12) then convert(char(1),4)+'-'+convert(varchar(4),year(getdate()))
            end

看不懂