Most edited posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100
p.CreationDate,
p.id as [Post Link],
case when p.PostTypeId = 1 then 'Question'
      when p.PostTypeId = 2 then 'Answer'
      else 'Other'
      end
as Type,
count(*)
from posts p
join posthistory h on h.postid = p.id
where PostHistoryTypeId = 5
group by h.postid, p.id, p.CreationDate, p.PostTypeID
order by count(*) desc

Enter Parameters

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