Post length

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- My Posts By Post Length
-- All of my answers with a score of 1 sorted by Body length

SELECT
  Id,
  Id as [Post Link],
  LEN(Body) as [Post Length]
FROM Posts
WHERE
  OwnerUserId = ##UserId## AND PostTypeId = 2 AND Score = 1
ORDER BY
  [Post Length] DESC

Enter Parameters

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