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 10 dateadd(hour, datediff(hour, 0, dateadd(hour, 0, p.creationdate)), 0), u.location--, count(u.location)
from posts p
inner join users u 
on (u.id = p.owneruserid)
where p.PostTypeId = 2 -- answer
and p.creationdate >= '2013-04-04' and p.creationdate <= '2013-04-04'
--group by  dateadd(hour, datediff(hour, 0, dateadd(mi, 30, p.creationdate)), 0), location
--u.websiteurl, u.location, u.aboutme,

fork query

edited nov 22 13

created nov 22 13 David Freitas