Amount of Posts per Post Length

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

-- Amount of Posts per Post Length

SELECT
  FLOOR(LEN(Body)/500) * 500 AS [Post Length],
  COUNT(Id) AS [Amount of Posts]
FROM
  Posts
WHERE
  PostTypeId = 2
GROUP BY
  FLOOR(LEN(Body)/500) * 500
ORDER BY [Amount of Posts] DESC

Enter Parameters

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