0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

select top 100 Id as [Post Link], CreationDate, LastActivityDate
          from Posts
         where PostTypeId = 1
           and Score <= 0
           and LastActivityDate < DATEADD(m, -6, GETDATE())
      order by LastActivityDate desc

fork query

edited sep 5 12

created sep 5 12 anonymous