0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for peer programmer code reviews

-- Enter Query Title
-- Enter Query Description

select TOP 500
    Posts.ID as [Post Link],
    Count(distinct RevisionGUID) as [Revisions in first ##Minutes:int?5## minutes]
from Posts inner join PostHistory on Posts.Id = PostHistory.PostId
           and DateAdd(minute, ##Minutes:int?5##, Posts.CreationDate) > PostHistory.CreationDate
where PostTypeId = 1 -- question
group by Posts.Id
order by Count(distinct RevisionGUID) desc

view current version

edited jul 23 14

created jan 17 14 rolfl