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
> 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
>
> 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
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
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
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
>
>
> > -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
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
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
; 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:
>
>
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
> ---
>
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 |
12 matches
Mail list logo