Find the questions which took the shortest time to be closed
Q&A for pro webmasters
-- Quickest closed questions -- Find the questions which took the shortest time to be closed SELECT TOP 50 Id as [Post Link], CreationDate, ClosedDate, DateDiff(second, CreationDate, ClosedDate) FROM Posts WHERE ClosedDate > '2000-01-01 00:00:00' ORDER BY DateDiff(second, CreationDate, ClosedDate);