SELECT Id, P.PostTypeId, Score, 'Max', 'Count', RANK() ov...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A for linguists, teachers and students of the Ukrainian language

SELECT Id, P.PostTypeId, Score, 'Max', 'Count', RANK() over (PARTITION BY P.PostTypeId ORDER BY Score DESC) as 'Rank'
  FROM Posts as P LEFT JOIN 
     (SELECT PostTypeId, MAX(Score) as 'Max', COUNT(*) as 'Count'
        FROM Posts
        GROUP BY PostTypeId
      ) as M ON (P.PostTypeId = M.PostTypeId)
  ORDER BY P.PostTypeId, 'Rank'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results