0

Please login or register to vote for this query.

(click on this box to dismiss)

Of selecting stuff

Q&A for pro webmasters

-- Stefano Example
-- Of selecting  stuff

DECLARE @latest datetime
SELECT TOP 1 @latest = CreationDate FROM Posts ORDER BY Id DESC

SELECT Id AS [Post Link], Score, OwnerUserId AS [User Link] FROM Posts
WHERE LastEditDate <  '2011-02-01'
AND ClosedDate IS NULL
AND PostTypeId = 1
ORDER BY LastActivityDate DESC

fork query

created jun 10 11 Marco Ceppi