So i have multiple Columns with the same data type entry but i need to combine them into a single column. i have 25 columns id like to list in one column in the same order
所以我有多个具有相同数据类型条目的列,但我需要将它们组合成一个列。我有25列id,喜欢以相同的顺序列在一列中
Example:
D1 D2 D3 D4
15 19 16 22
Ds
15
19
16
22
1 个解决方案
#1
2
I think you jus want union all, as your tags suggest:
我认为你们希望联合所有,因为你的标签建议:
select d1 as ds from t union all
select d2 as ds from t union all
select d3 as ds from t union all
select d4 as ds from t ;
#1
2
I think you jus want union all, as your tags suggest:
我认为你们希望联合所有,因为你的标签建议:
select d1 as ds from t union all
select d2 as ds from t union all
select d3 as ds from t union all
select d4 as ds from t ;