> Seems to work ok for me. What values were you expecting?

Yes, that works. Bad example on my part, sorry.

What doesn't work is this:

1|2|-7
2|2|-5
3|2|-20
4|2|-5
5|2|-2

SELECT max(Data) FROM (SELECT Data FROM test_table WHERE ExternalID=2);

This returns a -5, while I'm expecting a -2.

Thank you,

   Dennis


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to