Open posts with body character count of 25 or less sorted (asc) by vote count

1

Please login or register to vote for this query.

(click on this box to dismiss)

Looking at open posts with less than 26 characters in it by vote count.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Open posts with body character count of 25 or less.
-- Looking at posts with less than 31 characters in it

SELECT
    ParentId as [Post Link],
    body,
    len(body),
    score
FROM posts
WHERE posttypeid = 2 AND len(body) < 25 and closeddate IS NULL
ORDER BY score ASC;

Enter Parameters

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