select case when datepart(quarter,date) = 1 then '第一季度' when datepart(quarter,date) = 2 then '第二季度' when datepart(quarter,date) = 3 then '第三季度' else '第四季度' end, **** from table where case when datepart(quarter,date) = 1 then '第一季度' when datepart(quarter,date) = 2 then '第二季度' when datepart(quarter,date) = 3 then '第三季度' else '第四季度' end ='${季度}' |