Top daily edits

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

Select Top 100 UserId As [User Link], DATEADD(dd, 0, DATEDIFF(dd, 0, CreationDate)) As [Date], Count(Id) As DailyEdits
From PostHistory
Where UserId <> -1
Group By UserId, DATEADD(dd, 0, DATEDIFF(dd, 0, CreationDate))
Order By DailyEdits Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results