0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select *
from 
( 
  SELECT Id     a     -- aggregate
       , postid      -- group by
       , VoteTypeId  -- columns 
   FROM Votes
) src
PIVOT 
( 
  count(a) -- what we aggregate on 
  FOR VoteTypeId  in ([1], [2], [3]) -- accept, upmod, downmod
) pvt
order by [2] desc

fork query

edited dec 7 jon.doe37663

created apr 1 21 rene