0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

fork query

edited jul 30 15 Deer Hunter

created nov 22 10 mattjball