asked
Group by specified time period
Hi all consider the following : CREATE TABLE #request (request INT , creation DATE) INSERT INTO #request ( request, creation ) VALUES ( 2, -- request - int '2010-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 5, -- request - int '2010-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 3, -- request - int '2010-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 7, -- request - int '2011-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 4, -- request - int '2011-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 6, -- request - int '2011-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 8, -- request - int '2012-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 2, -- request - int '2012-06-06 14:56:27') -- registration - date INSERT INTO #request ( request, creation ) VALUES ( 9, -- request - int '2012-06-06 14:56:27') -- registration - date SELECT * FROM #request request creation 2 2010-06-06 5 2010-06-06 3 2010-06-06 7 2011-06-06 4 2011-06-06 6 2011-06-06 8 2012-06-06 2 2012-06-06 9 2012-06-06 What I want to see is this 10 2010-06-06 17 2011-06-06 19 2012-06-06 How do I group by a time period either i.e. minutes, hours, days, or years etc.? Thanks!
Something like this what you are after? SELECT SUM(request), creation FROM #request GROUP BY creation or SELECT SUM(request), DATEPART(YEAR,creation) FROM #request GROUP BY DATEPART(YEAR, creation)
This should do the trick: SELECT SUM(request), creation FROM #request GROUP BY creation GO Hope this helps!
10 People are following this question.
