PLSQL(oracle)中查询A表中name列(多条),结果用一条记录显示出来!
查询出来结果:
name1 name2 name3 ...
张三 李四 王五 ...
select a.name name1, b.name name2, c.name name3 ...... from
(
(select * from(select rowun num,name from A where ) where num =1) a
(..... (...)where num =2) b
() c
)
不要这样麻烦的,向各位大侠求个简单快速的查询语句