Q&A for professional and enthusiast programmers
SELECT TOP 20000 p.Id AS [A Id] , twn.Id AS [B Id] , p.CreationDate , p.PostTypeId AS [A Type] , twn.PostTypeId AS [B Type] , p.Tags AS [A Tags] , twn.Tags AS [B Tags] , p.Title AS [A Title] , twn.Title AS [B Title] FROM posts p INNER JOIN posts twn ON (p.CreationDate = twn.CreationDate AND p.Id < twn.Id) ORDER BY p.CreationDate , p.Id , twn.Id