We also show the creation date of the posts.
Q&A about the site for aircraft pilots, mechanics, and enthusiasts
-- Find identical titles -- We also show the creation date of the posts. 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 JOIN Posts AS b ON a.Title = b.Title WHERE a.Id < b.Id and a.ClosedDate IS NULL and b.ClosedDate IS NULL;