On May 16, 2014, at 6:25 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> So with SQLite, the query without max() would work, and produce expected > results. With another database engine that enforces SQL rules more strictly, > the query without max() would fail with a syntax error. I figured I'd do it > by the book and wrap the field into an aggregate function. I could have used > max(), or min(), or avg() - it doesn't matter which, they all work the same > when there's only one row to aggregate. Good man. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users