Posts with highest count of duplicates

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select relatedpostid as [Post Link] 
,      count(*) number_of_duplicates
from   postlinks pl
where  1=1
and    pl.linktypeid = 3  -- duplicate
group
by     relatedpostid
having count(*) > 1000
order
by     number_of_duplicates desc

Enter Parameters

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