创建数据透视表结构 [英] create Pivot Table structure
问题描述
我有一个表结构像这样:
EdpNo FullName PeriodMonth ITaxAmount Educess
16 RAJ KISHORE SHAW 4 1809 54
16 RAJ KISHORE SHAW 5 1812 54
16 RAJ KISHORE SHAW 6 3185 95
16 RAJ KISHORE SHAW 7 0 0
16 RAJ KISHORE SHAW 8 0 0
16 RAJ KISHORE SHAW 9 0 0
16 RAJ KISHORE SHAW 10 0 0
16 RAJ KISHORE SHAW 11 0 0
16 RAJ KISHORE SHAW 12 0 0
16 RAJ KISHORE SHAW 1 0 0
16 RAJ KISHORE SHAW 2 0 0
16 RAJ KISHORE SHAW 3 0 0
-------------------------------------- ---------------------------
我希望输出像:
FullName 4 5 6 7 8 9 10
RAJ KISHORE SHAW 1809 1812 3185 0 0 0 0
RAJ KISHORE SHAW 54 54 95 NULL NULL NULL NULL
应该怎么做到这一点输出类型。
您好,
检查这个...
简单使用方法SQL查询中的数据透视 [ ^ ]
希望这对您有所帮助。
干杯
I have a table Structure Like this :
EdpNo FullName PeriodMonth ITaxAmount EduCess
16 RAJ KISHORE SHAW 4 1809 54
16 RAJ KISHORE SHAW 5 1812 54
16 RAJ KISHORE SHAW 6 3185 95
16 RAJ KISHORE SHAW 7 0 0
16 RAJ KISHORE SHAW 8 0 0
16 RAJ KISHORE SHAW 9 0 0
16 RAJ KISHORE SHAW 10 0 0
16 RAJ KISHORE SHAW 11 0 0
16 RAJ KISHORE SHAW 12 0 0
16 RAJ KISHORE SHAW 1 0 0
16 RAJ KISHORE SHAW 2 0 0
16 RAJ KISHORE SHAW 3 0 0
-----------------------------------------------------------------
And I want Output Like :
FullName 4 5 6 7 8 9 10
RAJ KISHORE SHAW 1809 1812 3185 0 0 0 0
RAJ KISHORE SHAW 54 54 95 NULL NULL NULL NULL
How should got this type of output.
Hi,
Check this...
Simple Way To Use Pivot In SQL Query[^]
Hope this will help you.
Cheers
这篇关于创建数据透视表结构的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!