1

Please login or register to vote for this query.

(click on this box to dismiss)

Answers that are submitted right after the questions were posted

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT TOP 200
  a.Id [Post Link],
  a.Score,
  DATEDIFF(s, q.CreationDate, a.CreationDate) [Interval],
  q.CreationDate [qDate],
  a.CreationDate [aDate]
FROM Posts q
JOIN Posts a ON a.ParentId = q.Id
WHERE a.DeletionDate IS NULL
  AND DATEDIFF(s, q.CreationDate, a.CreationDate) > 0
  AND q.OwnerUserId != a.OwnerUserId
ORDER BY DATEDIFF(s, q.CreationDate, a.CreationDate) ASC

fork query

edited nov 23

created nov 23 NearHuscarl