0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select top 10 Id, DATEDIFF(DAY, CreationDate, GetDate()), CreationDate, GetDate() --Score, Id as [Post Link], Tags
from Posts 
order by Id desc
--where 
-- Score > 500 
--  and PostTypeId = 1 
--  and ClosedDate is null
--  and 
--  DATEDIFF(DAY, CreationDate, GetDate()) < 7
--order by Score desc

view current version

edited aug 8 12

created aug 8 12 Alberto C. Rodríguez