在SQL Server中将行转换为具有特定条件的列 [英] Convert Rows to Columns With Specific Conditions in SQL Server

问题描述

我在SQL Server 2008中有一个这样的表

I have a table in SQL sever 2008 like this

ID Name Have
1  Book PageNumber    
2  Book Title
3  Book Papers
4  Car Wheels
5  Car Doors
6  Car Engine
7  Car Windows

我想这样改变列和行的顺序

I want to change the order of column and row like this

Name A          B      C       D
Book PageNumber Title  Papers  -
Car  Wheels     Doors  Engine  Windows

是否可以编写一个自动进行此更改的查询? 我已经在Microsoft Access中使用交叉表完成了此操作，但是在SQL中我没有任何想法.

Is it possible to write a query that automatically make this change? I have done this in Microsoft Access with Cross Table but in SQL i don't have any idea.

致谢

推荐答案

您可以使用结果:

NAME    A               B         C         D
------------------------------------------------------------
Book    PageNumber      Title     Papers    (null)
Car     Wheels          Doors     Engine    Windows

SQLFiddle演示

这篇关于在SQL Server中将行转换为具有特定条件的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！