We also show the creation date of the posts.
Q&A for professional and enthusiast programmers
-- Find identical titles SELECT a.Id AS [Post Link], a.CreationDate AS "First Date", b.Id AS [Post Link], b.CreationDate AS "Second Date" FROM Posts AS a, Posts AS b WHERE a.Id < b.Id AND a.Title = b.Title;