Re: [sqlite] sqlite select max(field1), field2 from table1

2012-09-12 Thread Simon Slavin
On 12 Sep 2012, at 1:03pm, Richard Hipp wrote: > On Wed, Sep 12, 2012 at 7:51 AM, Tim Streater wrote: > >> On 12 Sep 2012 at 11:37, Richard Hipp wrote: >> >>> On Wed, Sep 12, 2012 at 6:15 AM, Bart Smissaert >>>

Re: [sqlite] sqlite select max(field1), field2 from table1

2012-09-12 Thread Richard Hipp
On Wed, Sep 12, 2012 at 7:51 AM, Tim Streater wrote: > On 12 Sep 2012 at 11:37, Richard Hipp wrote: > > > On Wed, Sep 12, 2012 at 6:15 AM, Bart Smissaert > > wrote: > > > >> Had a look at the new option as in the SQL above. > >>

Re: [sqlite] sqlite select max(field1), field2 from table1

2012-09-12 Thread Tim Streater
On 12 Sep 2012 at 11:37, Richard Hipp wrote: > On Wed, Sep 12, 2012 at 6:15 AM, Bart Smissaert > wrote: > >> Had a look at the new option as in the SQL above. >> Noticed it will only return one record, even if there are more records >> where >> field1