Get edits per day for specific user

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 DATEADD(dd, 0, DATEDIFF(dd, 0, CreationDate)) As [Date], Count(Id) As DailyEdits
From PostHistory
Where UserId=##UserID##
Group By DATEADD(dd, 0, DATEDIFF(dd, 0, CreationDate))
Order By DailyEdits Desc

Enter Parameters

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