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

Reply via email to