SQL如何实现行转列

MissYaaa

于 2020-06-01 10:20:10 发布

阅读量328

点赞数

文章标签： sql

本文链接：https://blog.youkuaiyun.com/MissYaaa/article/details/106467340

版权

select SerialNumber,
max (case when df.Description='ActualWeight' then PD.Content else '' end) as ActualWeight,
max (case when df.Description='DeliveryID' then PD.Content  else '' end) as DeliveryID,
max (case when df.Description='Dimension' then PD.Content  else '' end) as Dimension,
max(case when df.Description='PONUMBER' then PD.Content   else '' end) as PONUMBER
from dbo.ffPackage P 
inner join dbo.ffPackageDetail PD on PD.PackageID = P.ID 
inner join dbo.luPackageDetailDef DF on DF.ID = PD.PackageDetailDefID
where pd.PackageDetailDefID in('4','6','8','11') group by p.SerialNumber
--inner join dbo.ffPackageHistory PH on PH.PackageID = P.ID