更新时间:2023-02-06 17:47:59
您可以使用 row_number()
枚举行并制作 pivot
:
You could enumerate rows with row_number()
and make pivot
:
select *
from (
select d.*, row_number() over(partition by type order by id) rn from data d)
pivot (max(type) type, max(id) id for type in ('test1' t1, 'test2' t2))