我有一个查询,似乎无法解决。我想更改结果集,使其为1列,并且可以为N行。
原始查询
select src_approval,dst_approval
from example_table
where id = 62615
group by src_approval,dst_approval
我尝试了以下不正确的方法。
select src_approval,dst_approval
from example_table
unpivot
( colvalue for col in (src_approval,dst_approval) )
where id = 62615
group by src_approval,dst_approval
我尝试了以下操作,但仍然可以给我2列
select *
from (
select src_approval,dst_approval
from example_table
where id= 62615
group by src_approval,dst_approval
)
unpivot
( income_component_value
for income_component_type in (src_approval,dst_approval)
)
结果
select *
from (
select src_approval,dst_approval
from exemption_policies
where exemption_id = 62615
group by src_approval,dst_approval
)
unpivot
( owner
for approval in (src_approval,dst_approval)
)