On Tue, Sep 28, 2010 at 3:32 AM, Ian Hardingham <[email protected]> wrote: > Hey guys. > > If I have a table with a PRIMARY KEY AUTOINCREMENT id column, and I have > an id for a row, is there an Order(1) method of selecting the next row? > > I can't necessarilly guarantee that id + 1 exists, as it may be deleted. >
Hi Ian, Try WHERE id>previousid ORDER BY id LIMIT 1. -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
