0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

fork query

edited apr 2 14

created apr 2 14 Sathya