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.
