0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT top 100 
  question.id as [Post Link],
  question.ownerUserID as [User Link],
  answer.ownerUserID as [User Link],
  datediff(second, question.CreationDate, answer.CreationDate) as Delay
FROM posts as question
  INNER JOIN posts as answer
    ON question.acceptedAnswerID = answer.id
    AND question.ownerUserID != answer.ownerUserID
WHERE
  datediff(second, question.CreationDate, answer.CreationDate) BETWEEN 0 and 600
ORDER BY question.CreationDate DESC

fork query

created mar 13 14 Tim Stone