"Best" posts prior to 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

All questions that start with the word "Best" and were asked before 2010

Stack Overflow

Q&A for programmers

-- "Best" posts prior to 2010
-- All questions that start with the word "Best" and were asked before 2010

select
  CreationDate, Id as [Post Link], Body, Score from Posts
where
  upper(Title) like 'BEST%' and
  ParentId is null and
  ClosedDate is null and
  cast(CreationDate as DATE) < cast('2010-01-01 00:00:00.000' as DATE)
order by Score asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached