Question

oracle 视图sql语句怎么写

现有表1
列a 列b
1 a
2 b
1 c
2 d
创建视图成
列a 列b 列c
1 a c
2 b d
sql怎么写啊

多谢
图片

Answer 1

select 列a, ltrim(max(sys_connect_by_path(列b,',')),',') 列b
from (select 列a,privname,seq,lag(seq) over(partition by 列a order by seq) seq_new
from ( select 列a,列b, row_number() over(order by 列a) seq
from 表1
)
)
start with seq_new is null
connect by prior seq = seq_new
group by 列a;