如何将数据透视到新列中

Question

我有一个部署表，用于跟踪部署到每个环境的代码版本。它看起来像这样:

tbody> <<tr>BPMBPM

Application_Name	环境	版本
Biztalk	QA1	1.0.0.1
Biztalk	QA1	1.0.0.2
Biztalk	QA2	1.0.0.2
	QA1	1.0.0.1
	QA2	1.0.0.2
Websphere	QA1	1.0.0.1
Websphere	QA2	1.0.0.2

使用下列查询

select *,case when QA1 = QA2 then 1 else 0 end as match
from
(
select *
from Deployment_History
) as SourceTable  
pivot
(
max(Version) for Environment in(QA1,QA2)
) as PivotTable

demo indb<>fiddle