0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT Id, Title, PostTypeId, Score, 
Rank() OVER(ORDER BY Score) AS Rank, 
MAX(Score) AS MaxScoreByType

FROM Posts

GROUP BY Id, Title, PostTypeId, Score

fork query

edited jan 24

created jan 24 anonymous