Re: [GENERAL] Getting current and average on a single row

2010-11-24 Thread Mark Morgan Lloyd
Adrian Klaver wrote: On Wednesday 24 November 2010 1:08:27 am Mark Morgan Lloyd wrote: What is best practice when extracting both current and average from a table? Demonstration table here contains data from a cheap weather station. I can obviously get the current reading like this: select tem

Re: [GENERAL] Getting current and average on a single row

2010-11-24 Thread Adrian Klaver
On Wednesday 24 November 2010 1:08:27 am Mark Morgan Lloyd wrote: > What is best practice when extracting both current and average from a > table? Demonstration table here contains data from a cheap weather station. > > I can obviously get the current reading like this: > > select temp_out, dewpoin