> > SQLite allows this as an extension. When this happens, a value from an > arbitrary row within the group is reported. This is often convenient. > Ha ha, you must be joking, right? Otherwise, you must enlighten me on how it could have a practical use to have an arbitrary value in the group returned together with the total number of records across all the groups.
> > The result is strange and misleading and can easily lead to data errors. > > If you don't like this facility, don't use it in your queries. No one's forcing you. > -- Again, assuming that you are joking here :-). But just in case you are not: Well, in my work with SQL across a number of databases, this is one of the very common errors: to accidentally leave out an element in the group by clause of the SELECT statement and so many tools give a error rather than proceed. I think it should be with the same for SQLite -- at least as an option -- or even better: an option to enable the extension with this weird behaviour should one require it for some obscure reason. /Frank Missel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
