SQL查詢連接Oracle中多行的列值是否可以構(gòu)造SQL來連接多行的列值?以下是一個(gè)例子:表APID
A
B
C表BPID SEQ Desc
A 1 Have
A 2 a nice
A 3 day.
B 1 Nice Work.
C 1 Yes
C 2 we can
C 3 do
C 4 this work!SQL的輸出應(yīng)該是-PID Desc
A Have a nice day.
B Nice Work.
C Yes we can do this work!因此,基本上,輸出表的Desc列是表B中SEQ值的級(jí)聯(lián)嗎?對(duì)SQL有幫助嗎?
SQL查詢連接Oracle中多行的列值
幕布斯6054654
2019-06-01 15:48:47