0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 'Reputation' AS reputation,   
  [10], [20], [30], [40], [50]  
FROM  
(
SELECT Id, Reputation   
  FROM Users
) AS SourceTable  
PIVOT  
(  
  count(Id)  
  FOR Reputation IN ([10], [20], [30], [40], [50])  
) AS PivotTable;

fork query

edited mar 27

created mar 26 anonymous