Sql Query PIVOT - Row into column [英] Sql Query PIVOT - Row into column

问题描述

我在下表中获取值时遇到问题。



表：TestTable

Hi,

I have problem in fetching value in the table as like below.

Table : TestTable

ID            Name             Dept              ExpiryDate
1            Rajesh              IT                 23-Jan-16 
2            Keerthi             CSE                23-Jan-16
3            Rajesh              Mech               24-Jan-16
4            Venkat              IT                 28-Jan-16
5            VenKat              IT                 29-Jan-16
6            Priya               CSE                30-Jan-16 

输出：

Output :

Name           IT               CSE                 MECH

Rajesh        23-Jan-16                          24-Jan-16

Keerthi                      23-Jan-16

Venkat        29-Jan-16     

Priya         30-Jan-16

我需要将Name命名为Row和Dept into Columns。 ExpiryDate为值。





谢谢，

Suresh

I need Name into Row and Dept into Columns. ExpiryDate as values.


Thanks,
Suresh

推荐答案

尝试：

SELECT *
FROM (SELECT Name, Dept, ExpiryDate FROM TestTable) a
PIVOT (
   MAX(ExpiryDate) 
   FOR Dept in ([IT], [CSE],[Mech]) 
) AS data

这篇关于Sql Query PIVOT - Row into column的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！