Re: [sqlite] GROUP BY syntax

General Discussion of SQLite Database Subject: Re: [sqlite] GROUP BY syntax On Mon, Jun 17, 2013 at 12:03 PM, Dave Wellman <dwell...@ward-analytics.com>wrote: > Hi, > > Igor and Richard - thanks for your answers. > > Following up on the example below from Igor, what is the use cas

Re: [sqlite] GROUP BY syntax

un...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: 17 June 2013 14:01 > To: sqlite-users@sqlite.org > Subject: 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 qu

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

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

[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