SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)

by

GROUP BY UNIX_TIMESTAMP(time_stamp) DIV 30

or say for some reason you wanted to group them in 20-second intervals it would be DIV 20 etc. To change the boundaries between GROUP BY values you could use

GROUP BY (UNIX_TIMESTAMP(time_stamp) + r) DIV 30

where r is a literal nonnegative integer less than 30. So

GROUP BY (UNIX_TIMESTAMP(time_stamp) + 5) DIV 30

should give you sums between hh:mm:05 and hh:mm:35 and between hh:mm:35 and hh:mm+1:05.

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. Error related to only_full_group_by when executing a query in MySql
  4. SQL query return data from multiple tables
  5. MySQL Query GROUP BY day / month / year
  6. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  7. Grouping into interval of 5 minutes within a time range
  8. MySQL SELECT only not null values
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. MySQL “Group By” and “Order By”
  11. Group mysql query by 15 min intervals
  12. SQL Query to get column values that correspond with MAX value of another column?
  13. MySQL Group By and Sum total value of other column
  14. Checking multiple columns for one value
  15. Using Count to find the number of occurrences
  16. What does SQL clause “GROUP BY 1” mean?
  17. Using ORDER BY and GROUP BY together
  18. MySQL INSERT INTO … VALUES and SELECT
  19. How to select one row randomly taking into account a weight?
  20. GROUP BY – do not group NULL
  21. MySQL GROUP BY DateTime +/- 3 seconds
  22. Compare only day and month with date field in mysql
  23. Sum results of a few queries and then find top 5 in SQL
  24. Syntax error when using except in a query
  25. SELECT query return 1 row from each group
  26. MySQL INNER JOIN select only one row from second table
  27. SQL query to check if a name begins and ends with a vowel
  28. How to SELECT by MAX(date)?
  29. MySQL Group By Hours
  30. SQL query with avg and group by

Leave a Comment