Copy-pasted answers


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 [#], 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 = p.parentid
  where posttypeid = 2
order by p.body

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results