Most duplicated questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT
  L.RelatedPostId as [Post Link],
  COUNT(*) AS Duplicates,
  P.ViewCount,
  P.AnswerCount,
  P.ClosedDate
FROM
  PostLinks L
  join Posts P on (L.RelatedPostId = P.id)
WHERE
  LinkTypeId = 3
GROUP BY RelatedPostId, P.ViewCount, P.AnswerCount, P.ClosedDate
ORDER BY Duplicates DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results