[sqlite] SELECT DISTINCT question

2016-05-10 Thread dandl
f Of Keith Medcalf > Sent: Tuesday, 10 May 2016 12:59 PM > To: SQLite mailing list > Subject: Re: [sqlite] SELECT DISTINCT question > > > select col1, aggregateFunction(col2) from table group by col3 order by col1 > > returns the result of the aggregate function applied to a

[sqlite] SELECT DISTINCT question

2016-05-10 Thread dandl
> bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf > Why are you using BOTH distinct and group by on the same column? You only > need one or the other. If you are redundantly redundant I would hope that > the optimizer makes redundant (as in gets rid of, for those that are not >

[sqlite] SELECT DISTINCT question

2016-05-10 Thread dandl
> Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] Im Auftrag von Scott Robison > Gesendet: Montag, 09. Mai 2016 08:13 > An: SQLite mailing list > Betreff: Re: [sqlite] SELECT DISTINCT question > > On Sun, May 8

[sqlite] SELECT DISTINCT question

2016-05-10 Thread dandl
lf Of Scott Robison > Sent: Monday, 9 May 2016 4:13 PM > To: SQLite mailing list > Subject: Re: [sqlite] SELECT DISTINCT question > > On Sun, May 8, 2016 at 7:45 PM, dandl wrote: > > > Just to add to the below: > > > > S#| SNAME | STATUS | CITY > &g

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Keith Medcalf
d internally.) > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of dandl > Sent: Monday, 9 May, 2016 18:19 > To: 'SQLite mailing list' > Subject: Re: [sqlite] SELECT DISTINCT

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
At this point, backward compatibility. Enough people use it expecting it to work that it would be bad to change the behavior. On Mon, May 9, 2016 at 6:42 PM, dandl wrote: > > bounces at mailinglists.sqlite.org] On Behalf Of Keith Medcalf > > > Why are you using BOTH distinct and group by on the

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
> > > > -Original Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > > bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison > > Sent: Monday, 9 May 2016 4:13 PM > > To: SQLite mailing list > > Subje

[sqlite] SELECT DISTINCT question

2016-05-09 Thread dandl
sts.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of dandl > Sent: Monday, 9 May 2016 11:28 AM > To: 'SQLite mailing list' > Subject: [sqlite] SELECT DISTINCT question > > I have the following query: > > SELECT DISTINCT "EVALA112"(&q

[sqlite] SELECT DISTINCT question

2016-05-09 Thread dandl
I have the following query: SELECT DISTINCT "EVALA112"("S#") AS "^" FROM "S" ORDER BY "S#" ASC ; [This is generated code, not hand-written. The table S is from CJ Date sample data.] This query appears to work correctly. The function is an aggregation, and requires the data to be sorted. This

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Keith Medcalf
; From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of dandl > Sent: Sunday, 8 May, 2016 19:45 > To: 'SQLite mailing list' > Subject: Re: [sqlite] SELECT DISTINCT question > > Just to add to the below: > >

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Hick Gunter
Auftrag von Scott Robison Gesendet: Montag, 09. Mai 2016 08:13 An: SQLite mailing list Betreff: Re: [sqlite] SELECT DISTINCT question On Sun, May 8, 2016 at 7:45 PM, dandl wrote: > Just to add to the below: > > S#| SNAME | STATUS | CITY > --- >

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
On Sun, May 8, 2016 at 7:45 PM, dandl wrote: > Just to add to the below: > > S#| SNAME | STATUS | CITY > --- > S1| Smith | 20 | London > S2| Jones | 10 | Paris > S3| Blake | 30 | Paris > S4| Clark | 20 | London > S5| Adams |