select a,b,a1,b1 from
(select a,b,row_number() over(order by b) c from x where a = '2-6-9') z1
left join (select a1,b1,row_number() over(order by b) c1 from x where a = '2-6-9-16') z2 on c=c1
group by a,b,a1,b1
1min目标场景问卷
立即参与
