On 14/10/10 17:26, Kavita Raghunathan wrote: > I found an example: > Select * from<tblxyz> order by ID where limit 1 offset n-1 > > Will retreive the nth row. > In this case order by ID is probably not necessary as its already ordered > with a few missing rows.
It might happen to be ordered - but that is an implementation detail. Unless you use the ORDER BY clause the database may deliver the records in any order it wishes. It is not forced to use the ID order. -- Alan Chandler http://www.chandlerfamily.org.uk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
