SELECT ID, Title, PostTypeId, Score, MAX(Score) OVER(PART...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT
ID,
Title,
PostTypeId,
Score,
MAX(Score) OVER(PARTITION BY PostTypeId) AS MaxScoreType,
RANK() OVER(PARTITION BY PostTypeId ORDER BY Score DESC) AS Rank

FROM Posts

GROUP BY

ID,
Title,
PostTypeId,
Score

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results