> > select max(rowid) from sometable; > > Looks good and is instantaneous. Thank you very much.
And will only work if you never delete any rows from the table. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users