您的位置:首页 > 博客中心 > 数据库 >

oracle 列转行

时间:2022-03-14 00:50

with temp as(
  select ‘A01‘ nation ,1  as S1,2 as S2, 3 as S3 from dual union all
  select ‘A02‘ nation ,null  as S1,5 as S2, 6 as S3 from dual
)
select * from temp
unpivot(Qty for Sizes in(s1,s2,s3))

gxlsystem.com,布布扣

热门排行

今日推荐

热门手游