How do I get the standard deviation of the last 4 entries (there could be less than 4) of an integer column grouped by an integer ID entry in another column in the same table.
So data could be like this: ID xValue ---------------- 1 130 1 120 1 140 1 100 1 110 2 140 2 130 2 150 I know that SQLite doesn't have the SQRT function (and I can't make a UDF as I am doing this in an Android phone app) but I can do this last step in code. RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users