Most quickly closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions sorted by time between creation and closure

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

-- Most quickly closed questions
-- Questions sorted by time between creation and closure

select top 1000
    p.Id as [Post Link],
    datediff(ss, p.ClosedDate, p.CreationDate) as [Time Alive]
from Posts as p where
    p.ClosedDate is not null
    and p.PostTypeId = 1
order by [Time Alive]

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results