0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

select Top 100 OwnerUserId as [User Link], Count(*) as PostCount from Posts /*, month(p.CreationDate) as [Month]*/
where PostTypeId=1 and  CreationDate >= '12-01-2011'
Group By OwnerUserId /*, month(p.CreationDate)*/
Order By Count(*) desc

view current version

edited feb 1 12

created feb 1 12 christofian