On Mon, Jun 17, 2013 at 8:36 AM, Dave Wellman <dwell...@ward-analytics.com>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). > > If there is exactly one aggregate function which is either MIN() or MAX(), then the non-aggregated column values correspond to the row that contained the minimum or maximum value. If two or more rows contain the same minimum or maximum, then the specific one chosen is arbitrary. If there are two or more aggregate functions or the aggregate function is not MIN() or MAX() then the non-aggregate columns are selected arbitrarily. > > > Is the above syntax standard ANSI SQL? > > No. Most other SQL database engines call this a syntax error. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
