Short Answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

-- 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 to meta site
loading Hold tight while we fetch your results