SQL-如何在一列和两个结果中获取两个不同列的值？

Question

这个标题可能很奇怪，但我正在寻找一个可以做到这一点的查询：

我的表中有一行看起来像这样：

传感器地址|type_measure_1|type_mmeasure_2

我想做一个SQL查询，它可以给我这样的东西：

• 结果1:Sensor_address=X|type_measure=type_measure _1

• 结果2:Sensor_address=X(相同(|type_measure=type_measure _2

这在SQL中可能吗？

Answer 1

类似这样的东西：

SELECT Sensor_address, type_measure_1 as type_measure FROM [table] 
UNION ALL
SELECT Sensor_address, type_measure_2 as type_measure FROM [table]