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