Recent questions with a score of 5 or more.

0

Please login or register to vote for this query.

(click on this box to dismiss)

List of recent questions on a site with score of 5 or more, capped at 500

Stack Overflow

Q&A for professional and enthusiast programmers

-- Recent questions with a score of 5 or more.
-- List of recent questions on a site with score of 5 or more, capped at 500

SELECT TOP 500
  [Post Link] = Id,
  Score,
  CONVERT(VARCHAR(11), CreationDate, 106) AS CreationDate
FROM Posts
WHERE PostTypeId=1 and Score<=0
ORDER BY CreationDate DESC

Enter Parameters

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