转换列中行的查询
转换列中行的查询
提问于 2011-06-23 13:24:29
我想将行转换为列。IE:接受以下内容：
HOPPER_CLOSE_TIME HOPPER_OPEN_TIME SR_NO CAL_DONE PARTIAL_CALC_DONE_TIME
------------------------------------------------------------------------------------
23-06-2011 10:26:41 23-06-2011 10:29:23 535100 2 23-06-2011 10:28:41我想用这种方式
HOPPER_CLOSE_TIME 23-06-2011 10:26:41
HOPPER_OPEN_TIME 23-06-2011 10:29:23
SR_NO 535100
CAL_DONE 2
PARTIAL_CALC_DONE_TIME 23-06-2011 10:28:41回答 1
Stack Overflow用户
回答已采纳
发布于 2011-06-23 15:17:11
select HOPPER_CLOSE_TIME new_column_name from table1 where your_condition_here
union all
select HOPPER_OPEN_TIME new_column_name from table1 where your_condition_here
union all
select SR_NO new_column_name from table1 where your_condition_here
union all
select CAL_DONE new_column_name from table1 where your_conidtion_here
union all
selectnPARTIAL_CALC_DONE_TIME new_column_name from table1 where your_condition_here页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/6449694
复制相关文章
相似问题
腾讯云开发者
