Gabor Grothendieck mentioned a new feature of SQLite in 3.7.11:
Queries of the form: "SELECT max(x), y FROM table" returns the value of
y on the same row that contains the maximum x value.
Is that standard SQL behavior? I'd have expected that to return one row for
every row in the table. To get the behavior described above, I'd use "SELECT
x, y FROM table WHERE x = (SELECT max(x) FROM table)".
RobR
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
