SELECT listagg(PID,’,’) within group (order by PID)
FROM GO
where NO in
(‘000484Z19080101828’, ‘000485Z19080101829’,
‘000486Z19080101830’)
oracle多行合并一行,并用id隔开
最新推荐文章于 2023-11-10 17:05:44 发布
SELECT listagg(PID,’,’) within group (order by PID)
FROM GO
where NO in
(‘000484Z19080101828’, ‘000485Z19080101829’,
‘000486Z19080101830’)