Short Answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

-- Created by aminography [https://stackoverflow.com/users/1631967/aminography]

SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY Posts.CreationDate DESC) AS [#], 
    Posts.Id AS [Post Link],
    Posts.Body,
    LEN(Posts.Body) [Post Length],
    Posts.Score
    
FROM
    Posts
    
WHERE
  PostTypeId=2 AND LEN(Posts.Body)<30 AND Posts.Score<100

ORDER BY
    Posts.CreationDate DESC;

Enter Parameters

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