On 1/10/2013 12:04 PM, Eduardo Morras wrote:
Select max(x), y from t will return 2 colums and n rows
Not true. The query uses an aggregate function, so it will return one row per group. There's no GROUP BY clause, so the whole table is one group. Ergo, this query will always return exactly one row. Try it, see for yourself.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
