0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT TOP 10
  Posts.title, Posts.Id AS [Post Link], Posts.tags, Posts.CreationDate
FROM Posts
WHERE
  Posts.PostTypeId = 1 -- Questions
  -- AND Posts.CreationDate >= DATEADD(day,-7, GETDATE())
ORDER BY Posts.CreationDate

fork query

edited oct 21 17

created jun 6 16 anonymous