Questions that got an answer after they got closed


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select as [Post Link]
    ,  q.closeddate
    , as [Post Link]
    ,  a.creationdate
    , datediff(mi, q.closeddate, a.creationdate) as diff
from posts q 
inner join posts a on a.parentid =
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and q.closeddate is not null -- closed
and a.creationdate > q.closeddate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results