The fastest closed questions!

3

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT TOP(100) Id AS [Post Link],
                datepart(hh, ClosedDate - CreationDate) * 3600
                + datepart(mi, ClosedDate - CreationDate) * 60
                + datepart(ss, ClosedDate - CreationDate)
                as [Closed in X seconds]
FROM Posts
WHERE ClosedDate IS NOT NULL
ORDER BY ClosedDate - CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached