Re: [GENERAL] Help with select with max and min please

2010-08-08 Thread Jose Maria Terry
El 08/08/10 21:49, Edoardo Panfili escribió: On 08/08/10 20.47, Jose Maria Terry wrote: Hello all, I need to run a query on a table that holds logged data from several water flow meters. I need the first and last values (with their associated time) for every logger in a time range. I've trie

Re: [GENERAL] Help with select with max and min please

2010-08-08 Thread Edoardo Panfili
On 08/08/10 20.47, Jose Maria Terry wrote: Hello all, I need to run a query on a table that holds logged data from several water flow meters. I need the first and last values (with their associated time) for every logger in a time range. I've tried this that returns the min and max time in the

[GENERAL] Help with select with max and min please

2010-08-08 Thread Jose Maria Terry
Hello all, I need to run a query on a table that holds logged data from several water flow meters. I need the first and last values (with their associated time) for every logger in a time range. I've tried this that returns the min and max time in the desired range for every logger, but i