1

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы для программистов

DECLARE @CutoffDate datetime
SET @CutoffDate = dateadd(month, -6, GETUTCDATE()) 

select 
DATEFROMPARTS(year(CreationDate), month(CreationDate), day(CreationDate)) as [Date]
, count(*)
from Posts where ParentId is null and CreationDate > @CutoffDate
group by year(CreationDate), month(CreationDate), day(CreationDate)
order by year(CreationDate), month(CreationDate), day(CreationDate) asc

fork query

edited jul 20 15 J.F. Sebastian

created nov 22 10 mattjball