5

Please login or register to vote for this query.

(click on this box to dismiss)

We also show the creation date of the posts.

Q&A for developers and researchers interested in open data

-- 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;

fork query

created aug 31 11 PaulEbermann