Brannon King <[EMAIL PROTECTED]> wrote: > It's too bad you can't do an offset > of negative one so that it would start at the back. That should be darn > fast. Something like: > > 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; -- D. Richard Hipp <[EMAIL PROTECTED]>