Group mysql query by 15 min intervals

by 
SELECT   FLOOR(UNIX_TIMESTAMP(timestamp)/(15 * 60)) AS timekey
FROM     table
GROUP BY timekey;

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Using LIMIT within GROUP BY to get N results per group?
  3. Error related to only_full_group_by when executing a query in MySql
  4. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  5. Error in MySQL when setting default value for DATE or DATETIME
  6. Grouping into interval of 5 minutes within a time range
  7. Retrieving the last record in each group – MySQL
  8. Mysql query to dynamically convert rows to columns
  9. MySQL “Group By” and “Order By”
  10. MySQL Query to select data from last week?
  11. MySQL convert date string to Unix timestamp
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. Timestamp with a millisecond precision: How to save them in MySQL
  14. How to convert number of week into date?
  15. Set NOW() as Default Value for datetime datatype?
  16. SQL Query to show nearest date?
  17. In SQL, how to select the top 2 rows for each group
  18. SQL Query to get column values that correspond with MAX value of another column?
  19. MySQL Group By and Sum total value of other column
  20. What does SQL clause “GROUP BY 1” mean?
  21. Using ORDER BY and GROUP BY together
  22. MySql difference between two timestamps in days?
  23. MySQL: How do I join same table multiple times?
  24. How to get current date & time in MySQL?
  25. MySQL GROUP BY DateTime +/- 3 seconds
  26. how to cast the hexadecimal to varchar(datetime)?
  27. When is a timestamp (auto) updated?
  28. MySQL Group By Hours
  29. mysql count group by having
  30. SQL query with avg and group by

Leave a Comment