如何在sql server 2008中使用数据透视表查询 [英] how to use pivot table query in sql server 2008

问题描述

im use pivot table query for display the data...

in the Abc table 4 columns like SID (auto increment), StudentID, Attendance, Day.

select * from Abc
pivot (max (Attendance) for Day in ([Day1],[Day2],[Day3])) as DayWise

Output :-

 SID    StudentID    Day1   Day2   Day3
----------------------------------------
  1       101         A     null   null
  2       101        null    A     null
  3       101        null   null    A
  4       102         A     null   null
  5       103        null    A     null

But i want this type of output :-

StudentID    Day1   Day2   Day3
---------------------------------
101           A      A      A
102           A      A     null

So how can i do this....
Thanx in advance...

推荐答案

请参考这个网站我想你可能会找到你想要的输出



在SQL中使用Pivot的简单方法查询 [ ^ ]







http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/ [ ^ ]

Please refer this site i think you may find your desired output

Simple Way To Use Pivot In SQL Query[^]



http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/[^]

您好，

参考：如何使用SQL Pivot显示学生出勤率

thanks

Hello ,
Refer: How to Display student attendance using SQL Pivot
thanks

select distinct studentid,
(select attendance from abc where day='Day1' and abc.studentid=t1.studentid) day1,
(select attendance from abc where day='Day2' and abc.studentid=t1.studentid) day2,
(select attendance from abc where day='Day3' and abc.studentid=t1.studentid) day3
from abc t1

这篇关于如何在sql server 2008中使用数据透视表查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！