没有聚合功能的TSQL Pivot [英] TSQL Pivot without aggregate function

问题描述

我有一张这样的桌子...

I have a table like this...

CustomerID   DBColumnName   Data
--------------------------------------
1            FirstName      Joe
1            MiddleName     S
1            LastName       Smith
1            Date           12/12/2009
2            FirstName      Sam
2            MiddleName     S
2            LastName       Freddrick
2            Date           1/12/2009
3            FirstName      Jaime
3            MiddleName     S
3            LastName       Carol
3            Date           12/1/2009

我想要这个...

使用PIVOT可以吗?

Is this possible using PIVOT?

CustomerID  FirstName   MiddleName          LastName        Date
----------------------------------------------------------------------
1           Joe             S               Smith           12/12/2009
2           Sam             S               Freddrick       1/12/2009
3           Jaime           S               Carol           12/1/2009

推荐答案

您可以使用MAX聚合，它将仍然有效.一个值的最大值=该值.

You can use the MAX aggregate, it would still work. MAX of one value = that value..

在这种情况下，您还可以在customerid上自我连接5次，通过每个表引用的dbColumnName进行过滤.效果可能会更好.

In this case, you could also self join 5 times on customerid, filter by dbColumnName per table reference. It may work out better.

这篇关于没有聚合功能的TSQL Pivot的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！