We also show the creation date of the posts.
Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
-- 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;