1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @userId int = 41739; /* NOTE TO SELF: I'm 159145 on StacKoverflow, but 41739 on SuperUser. */

SELECT
    TOP 100
    c.PostId AS [Post Link],
    c.CreationDate,
    c.Score,
    c.[Text]
FROM 
    Comments AS c
WHERE
    c.UserId = @userId
    AND
    c.Score > 1
ORDER BY
    c.Score DESC;

fork query

edited jul 8

created jul 8 Dai