0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students and teachers of all martial arts

/*select top 10 id, CreationDate, score, title, tags from Posts where ParentId is null 
and CreationDate > DATEADD(ww, -6, GETDATE()) --'2011-10-01 00:00:00'
order by score desc
*/
select top 10 id, CreationDate, score, title, tags from Posts
order by creationdate desc

fork query

created nov 10 11 anonymous