第二种办法适用于V9.7.4以前的版本WITH x(F1,cnt,F2,empno, len)AS (SELECT F1 ,count(*) over(PARTITION BY F1 ),CAST(F2 AS VARCHAR(100)),F2 ,1 FROM aaaa UNION ALL SELECT x.F1,x.cnt,x.F2||','||e.F2,e.F2, x.len+1 ...
显示全部第二种办法适用于V9.7.4以前的版本
WITH x(F1,cnt,F2,empno, len)
AS (SELECT F1 ,count(*) over(PARTITION BY F1 ),CAST(F2 AS VARCHAR(100)),F2 ,1
FROM aaaa
UNION ALL
SELECT x.F1,x.cnt,x.F2||','||e.F2,e.F2, x.len+1
FROM aaaa e,x
WHERE e.F1=x.F1 AND e.F2>x.empno
)
SELECT F1,F2
FROM x
WHERE len=cnt --AND F2 LIKE 'V1,V2%'
ORDER BY F1
收起