Longest post(s) by user

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 10
  Id AS [Post Link],
  Score / LEN(Body) AS CharactersPerVote,
  Score,
  Body,
  CreationDate,
  LEN(Body) as Length
FROM Posts
WHERE OwnerUserId = '##UserId?3622940##'
AND PostTypeId = 2
ORDER BY Length DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results