There are no deletes on this table though. On 7/19/06, Sripathi Raj <[EMAIL PROTECTED]> wrote:
What does LIMIT 1 do? On 7/19/06, Brannon King <[EMAIL PROTECTED]> wrote: > > >> 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. > >