0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created nov 29 11 TomWij