select max(decode(name,'1',name) ) n1,max(decode(name,'2',name) ) n2 from testtble
oracle 行转列
最新推荐文章于 2024-07-31 14:31:55 发布
select max(decode(name,'1',name) ) n1,max(decode(name,'2',name) ) n2 from testtble