# 1、
cast(concat(a.periods, '01') as date) > date_sub(cast(concat('202202', '01') as date),INTERVAL 1 YEAR)
AND cast(concat(a.periods, '01') as date) <= cast(concat('202202', '01') as date)
# 2、
concat('201912'-100) and a.periods < concat('201912'+1)
# 3、
select (case (@i:=@i +1) when 1 then '-' else @i END) from (select @i := 0) m
【无标题】
于 2023-03-06 14:05:50 首次发布