1

Please login or register to vote for this query.

(click on this box to dismiss)

Questions sorted by time between creation and closure

Q&A about the site for members of the workforce navigating the professional setting

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

select top 1000
    p.Id as [Post Link],
    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]

fork query

created may 9 11 PleaseStand