0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

DECLARE @UserId INT = ##UserId:INT##

SELECT 

    ROW_NUMBER() OVER (ORDER BY c.Score DESC, c.CreationDate DESC) AS 'ID',
    c.PostID [Post Link],
    c.Score,
    c.CreationDate,
    u.DisplayName,
    c.Text

FROM Comments AS c
JOIN Posts AS p ON p.Id = c.PostId
JOIN Users AS u ON u.Id = p.OwnerUserId

WHERE c.UserId = @UserId

ORDER BY c.Score DESC, c.CreationDate DESC

view current version

edited feb 28

created feb 1 22 VBasic2008