Re: [sqlite] GROUP BY syntax

neral Discussion of SQLite Database Subject: Re: [sqlite] GROUP BY syntax On Mon, Jun 17, 2013 at 12:03 PM, Dave Wellman wrote: > Hi, > > Igor and Richard - thanks for your answers. > > Following up on the example below from Igor, what is the use case ? > SELECT field1, field2, m

Re: [sqlite] GROUP BY syntax

address: The Oriel, Sydenham Road, Guildford, Surrey, > United Kingdom, GU1 3SR > Registered company number: 3917021 Registered in England and Wales. > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igo

Re: [sqlite] GROUP BY syntax

Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: 17 June 2013 14:01 To: sqlite-users@sqlite.org Subject: Re: [sqlite] GROUP BY

Re: [sqlite] GROUP BY syntax

On 6/17/2013 8:36 AM, Dave Wellman wrote: So I think that what this is saying is that when you execute an aggregate query without a GROUP BY, the chosen non-aggregate values are random (i.e. arbitrary). This is true with GROUP BY as well - consider: select field1, field2, sum(field3) group by

Re: [sqlite] GROUP BY syntax

On Mon, Jun 17, 2013 at 8:36 AM, Dave Wellman wrote: > > > So I think that what this is saying is that when you execute an aggregate > query without a GROUP BY, the chosen non-aggregate values are random (i.e. > arbitrary). > > If there is exactly one aggregate function which is either MIN() or MA

[sqlite] GROUP BY syntax

Hi, The following sql was in a recent post which was complaining about performance and it looks like a solution has been provided for that. However, looking at the original SQL I would have expected an error message to be generated for it because there is no "GROUP BY" clause. SELECT dd