There is no requirement to use a GROUP BY clause with an aggregation function.
On Wed, Sep 7, 2016 at 12:02 PM, Michael Reed <[email protected]> wrote: > For instance, if I wanted the mean temperature over the past day, is the > following adequate or should I add a GROUP BY clause? Thank you > > SELECT MEAN(temperature) FROM measurement WHERE time > now() - 2d > > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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 https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/4d403db0-a16f-4360-8d8b-4fa29e43a2ac%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/4d403db0-a16f-4360-8d8b-4fa29e43a2ac%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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 https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvPFjbbeua4Un8rya%2BBMWrKrbMKzhsi5nVPkwqnif-AT9g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
