update last row in sqlite android

I'm trying to make a query that updates the last row in my table. here is the query I'm using:

String updateQuery = "Update table set col = '"+ bla +"' where id=SELECT max(id)";

but this gives mean error..I know how to update last row in SQL but I can't figure it out in SQLITE. What am I missing?