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 p.Id) Row, *
FROM Posts p
JOIN Users u ON u.Id=p.OwnerUserId
WHERE PostTypeId=1 AND DATEPART(YEAR, u.CreationDate)='2012'
ORDER BY p.OwnerUserId Desc

fork query

edited feb 14 13

created feb 14 13 anonymous