0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

select id,
Title,
PostTypeId,
Score,
rank() over(PARTITION BY PostTypeId order by Score asc) scorerank,
max(Score) over(PARTITION BY PostTypeId) maxscore
from Posts
order by RAND()

view current version

edited dec 5 21

created dec 5 21 anonymous