0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

-- Enter Query Title
    SELECT TOP 50 DisplayName, COUNT(*) As MinusOne
      FROM Comments 
INNER JOIN Users u
        ON UserId = u.Id
     WHERE (Text LIKE '%-1' OR Text LIKE '-1%' OR Text LIKE '% -1 %')
  GROUP BY UserId, DisplayName
  ORDER BY MinusOne DESC

-- Enter Query Description

fork query

created nov 14 11 NullUserException