Q&A about the site for members of the workforce navigating the professional setting
SELECT TOP(##num?500##) RANK() OVER(ORDER BY Score DESC) AS Rank, Score, Id AS [Comment Link], Text, UserId AS [User Link], UserDisplayName, CreationDate FROM Comments ORDER BY Score DESC