>> select rowid from table limit 1 offset -1; > Two ways to do this: > > SELECT rowid FROM table ORDER BY rowid DESC LIMIT 1; > SELECT max(rowid) FROM table;
Yes, but neither one of those would be as fast as this query, true? SELECT rowid FROM table LIMIT 1 I guess I was thinking to avoid the sort overhead.