Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

-- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results