Find identical titles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Find identical titles

SELECT a.Id AS [Post Link], a.Title AS First,
       b.Id AS [Post Link], b.Title AS Second
FROM Posts AS a, Posts AS b
WHERE a.Id < b.Id
AND a.Title = b.Title;

Enter Parameters

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