加个计算列
alter table tableName add 季度 as (case
when month(dateField)=12 and day(dateField)>=26 then '四季度'
when month(dateField)<3 then '四季度'
when month(dateField)=3 and day(dateField)<26 then '四季度'
when month(dateField)<6 then '一季度'
when month(dateField)=6 and day(dateField)<26 then '一季度'
when month(dateField)<9 then '二季度'
when month(dateField)=9 and day(dateField)<26 then '二季度'
when month(dateField)<12 then '三季度'
when month(dateField)=12 and day(dateField)<26 then '三季度'
else '' end
)