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)
Posted by Himanshu at 5:52 PM 0 comments
Labels: 5 mins, data, Group by, interval, query
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