Find duplicate question titles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds questions with non-distinct titles See https://meta.stackoverflow.com/q/422105/10871900

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Title, CONCAT('https://stackoverflow.com/q/',Id) AS 'Link'
FROM Posts
WHERE Title IN (
  SELECT Title
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY Title
  HAVING COUNT(*)>1
)
ORDER BY Title

Enter Parameters

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