How long until I get the pundit badge?

19

Please login or register to vote for this query.

(click on this box to dismiss)

List comments in order of score

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- How long until I get the pundit badge?
-- List comments in order of score

DECLARE @UserId int = ##UserId##

SELECT TOP 20 
    Posts.Title, Comments.Text, Comments.Score, Posts.Id, Posts.ParentId
FROM Comments
     INNER JOIN Posts ON Comments.PostId = Posts.Id
WHERE 
    UserId = @UserId
ORDER BY Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results