On 6/17/2013 8:36 AM, Dave Wellman wrote:
So I think that what this is saying is that when you execute an aggregate query without a GROUP BY, the chosen non-aggregate values are random (i.e. arbitrary).
This is true with GROUP BY as well - consider: select field1, field2, sum(field3) group by field1;
Is the above syntax standard ANSI SQL?
No, it's an extension implemented by SQLite. Most other DBMS produce an error for such statements.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
