--试试这个吧 同学,真搞不懂你的需求咋想的 WITH T1 AS( SELECT ROW_NUMBER()OVER(ORDER BY A) ROW_A,A FROM(SELECT DISTINCT A FROM 表名) ),T2 AS( SELECT ROW_NUMBER()OVER(ORDER BY B) ROW_B,B FROM(SELECT DISTINCT B FROM 表名) ),T3 AS( SELECT ROW_NUMBER()OVER(ORDER BY C) ROW_C,C FROM(SELECT DISTINCT C FROM 表名) )SELECT A,B,C FROM T1 FULL OUTER JOIN T2 ON ROW_A = ROW_B FULL OUTER JOIN T3 ON ROW_A = ROW_C;
--试试这个吧 同学,真搞不懂你的需求咋想的
WITH T1 AS(
SELECT ROW_NUMBER()OVER(ORDER BY A) ROW_A,A
FROM(SELECT DISTINCT A FROM 表名)
),T2 AS(
SELECT ROW_NUMBER()OVER(ORDER BY B) ROW_B,B
FROM(SELECT DISTINCT B FROM 表名)
),T3 AS(
SELECT ROW_NUMBER()OVER(ORDER BY C) ROW_C,C
FROM(SELECT DISTINCT C FROM 表名)
)SELECT A,B,C
FROM T1 FULL OUTER JOIN T2 ON ROW_A = ROW_B
FULL OUTER JOIN T3 ON ROW_A = ROW_C;