数据111212233334 求解select distinct numberfrom(selectnumber,id,lag(id,2) over(partition by number order by id) prefrom( selectnumber,row_number() over(partition by par order by par) idfrom (select number,1 as par from series)))where id = pre+2;