Top 10 duplicate Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select top 10
 RelatedPostId as [Post Link],
 count(*) as "Number of duplicates"

from PostLinks
 join Posts q on q.Id=RelatedPostId

where LinkTypeId=3

group by RelatedPostId
order by count(*) desc

Enter Parameters

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