给你一个例子。 你总共有6列,分别叫作F1,F2,F3,F4,F5,F6.表名T1 Select C From ( Select C1 AS C , C1 || '1' AS ORDERID FROM T1 UNION ALL Select C2 AS C , C1 || '2' AS ORDERID FROM T1 UNION ALL Select C3 AS C , C1 || '3' AS ORDERID FROM T1 UNION ALL Select C4 AS C , C1 || '4' AS ORDERID FROM T1 UNION ALL Select C5 AS C , C1 || '5' AS ORDERID FROM T1 UNION ALL Select C6 AS C , C1 || '6' AS ORDERID FROM T1 ) Order By OrderID
你总共有6列,分别叫作F1,F2,F3,F4,F5,F6.表名T1
Select C From (
Select C1 AS C , C1 || '1' AS ORDERID FROM T1
UNION ALL
Select C2 AS C , C1 || '2' AS ORDERID FROM T1
UNION ALL
Select C3 AS C , C1 || '3' AS ORDERID FROM T1
UNION ALL
Select C4 AS C , C1 || '4' AS ORDERID FROM T1
UNION ALL
Select C5 AS C , C1 || '5' AS ORDERID FROM T1
UNION ALL
Select C6 AS C , C1 || '6' AS ORDERID FROM T1
)
Order By OrderID