Hello! I write each minute in the databse: timestamp ; uid ; value min ; value avg ; value max
Now I need all values for a timespane of 60min in 5min grouped: from: timestamp - 60min to: timestamp aggregte all 5 min from"avg" MAX from "max" MIN from"min" also: from: timestamp - 24h to: timestamp aggregte all 1h from"avg" MAX from "max" MIN from"min How can I do this with an SQL Query? Thank you! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
