Re: [sqlite] problem with queries using group by

D. Richard Hipp wrote: SQLite has never "allowed" queries to have a GROUP BY clause unless there is an aggregate function in the result set. I belive the documentation says as much. Maybe it does somewhere else, but the Syntax page, under Select, says: "The GROUP BY clauses causes one or more row

Re: [sqlite] problem with queries using group by

On Fri, 14 Jan 2005 18:15:04 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Tiago Dionizio wrote: > > > Hi, > > > > I am using a recent copy from CVS and tried this: (sorry for the quick > > and dirty test) > > > > SQLite version 3.0.8 > > Enter ".help" for instructions > > sqlite> create tab

Re: [sqlite] problem with queries using group by

Tiago Dionizio wrote: Hi, I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test) SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used o

[sqlite] problem with queries using group by

Hi, I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test) SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used on aggregate queries