Re: [sqlite] GROUP BY question

Thanks everyone! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GROUP BY question

On May 24, 2012, at 7:22 PM, Mike King wrote: > Is this Select statement valid? In SQLite, yes. > In Oracle, it wouldn't be because > what is the aggregate of A. Right. SQLite tries nonetheless to return "something" . A bit of a (mis)feature IMO. > Is this behavior defined anywhere?

Re: [sqlite] GROUP BY question

On Thu, May 24, 2012 at 1:22 PM, Mike King wrote: > Is this Select statement valid?  In Oracle, it wouldn't be because > what is the aggregate of A.  Is this behavior defined anywhere? > > create table T (A,B); > insert into  T (A,B) values (1,3); > insert into  T (A,B) values

Re: [sqlite] GROUP BY question

On Thu, May 24, 2012 at 1:22 PM, Mike King wrote: > Is this Select statement valid? In Oracle, it wouldn't be because > what is the aggregate of A. Is this behavior defined anywhere? > > create table T (A,B); > insert into T (A,B) values (1,3); > insert into T (A,B) values

[sqlite] GROUP BY question

Is this Select statement valid? In Oracle, it wouldn't be because what is the aggregate of A. Is this behavior defined anywhere? create table T (A,B); insert into T (A,B) values (1,3); insert into T (A,B) values (2,3); select A,B from T group by B;