0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT top 100 Row_Number() OVER (Partition by OwnerUserId Order By Id) Row, *
FROM Posts
WHERE PostTypeId=1 AND DATEPART(YEAR, CreationDate)='2012'
ORDER BY OwnerUserId Desc

fork query

edited feb 14 13

created feb 14 13 anonymous