Hi, Such questions are typically best asked at StackOverflow.com.
You would need a function that converts the timestamp to a value with a 5 minute delay. Regards, Thomas On Wednesday, January 14, 2015, Hannes Hörting <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
