这个统计sql怎么写
图1转换到图2那种结果。。
voteValue列1代表A,2代表B,3,代表C,4代表D,5代表E

图1


图2



谢谢。。。
[解决办法]
case when
[解决办法]
try this,

select ListID,[1] 'A',[2] 'B',[3] 'C',[4] 'D',[5] 'E'
from
(select ListID,VoteValue,count(1) 'ct'
 from [tab] group by ListID,VoteValue) t
pivot(max(ct) for VoteValue in([1],[2],[3],[4],[5])) p

select ListID,
       isnull([1],0) 'A',
       isnull([2],0) 'B',
       isnull([3],0) 'C',
       isnull([4],0) 'D',
       isnull([5],0) 'E'
from
(select ListID,VoteValue,count(1) 'ct'
 from [tab] group by ListID,VoteValue) t
pivot(max(ct) for VoteValue in([1],[2],[3],[4],[5])) p