Fetch all questions posted on the First of April, sorted by decreasing order of score

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

SELECT id                         AS [Post Link],
       score,
       Datepart(yy, creationdate) AS "Year of Post",
       body                       "Contents of Question"
FROM   posts
WHERE  posttypeid = 1
       AND ( Datepart(mm, creationdate) = '04'
             AND Datepart(dd, creationdate) = '01' )
ORDER  BY score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results