Q&A for scientists using computers to solve scientific problems
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