4

Please login or register to vote for this query.

(click on this box to dismiss)

To find those that required a lot of work. :-) Or a copy/paste. :-(

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- The longest answers.
-- To find those that required a lot of work. :-)
-- Or a copy/paste. :-(

SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User Link], LEN(Body) AS Length, LastActivityDate AS [Last Activity Date]  FROM Posts WHERE PostTypeId = 2 ORDER BY Length DESC

fork query

edited apr 12 12 David Zaslavsky

created jun 20 11 TomWij