skip to main
|
skip to sidebar
Aavo Aavo!!
Monday, January 17, 2011
Group by query data based on 5 mins interval
Select count(id) from table_Name group by dateadd(minute,(datediff(minute,0,time_stamp)/5)*5,0)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Blog Archive
▼
2011
(1)
▼
January
(1)
Group by query data based on 5 mins interval
►
2010
(1)
►
March
(1)
►
2009
(1)
►
March
(1)
►
2008
(12)
►
December
(1)
►
August
(1)
►
June
(4)
►
May
(1)
►
April
(2)
►
February
(3)
►
2007
(1)
►
May
(1)
About Me
Himanshu
View my complete profile