Copy-pasted answers

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 countof as [#], p.id as [Post Link], p.owneruserid as [User Link],
       q.closeddate as [Closed Date]
  from posts p
  inner join (select
              body, count(*) as countof
              from posts
              where posttypeid = 2
              group by body
              having count(*) > 1)
        dt on p.body = dt.body
  inner join (select id, closeddate from posts)
        q on q.id = p.parentid
  where posttypeid = 2
order by p.body

Enter Parameters

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