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 WHERE (CreationDate >= '##Date1?2021-01-01##') AND (CreationDate <= '##Date2?2022-01-01##') ORDER BY Score DESC