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. Thank you! Kavita On 10/14/10 11:15 AM, "Kavita Raghunathan" <kavita.raghunat...@skyfiber.com> wrote: > Please see comment > > > On 10/14/10 11:02 AM, "P Kishor" <punk.k...@gmail.com> wrote: > > >>> Hello, >>> I¹ve been adding and deleting rows from the sqlite database. Now the primary >>> ID is non-sequential. >>> >>> >>> 1. How do I get the nth entry in the database >>> 2. AND, How do I get the first n rows from the database ? >>> >> >> Both "nth" and "first n" depend upon the sort order. Sort the table >> the way you want, and then get the nth or the first n (use >> LIMIT/OFFSET) to get the desired rows. >> >> The db by itself has no sort order, although, if you have numeric PK, >> there is an implicit ascending sort on PK. >> > > Yes, I have numeric PK. I don't want to sort the table, the way it was added > in ascending order of PK, I want it the same way, because the entries are > historical events based on order of occurance. Now, when I added, the PK was > 1,2,3,...100. I have since say deleted 2,5,11 because the events are no > longer relavant. Now I want the first 10 entries, which will be > 1,3,4,6,7,8,9,10,12,13. You are saying I can use LIMIT/OFFSET to do that? I > do not need to order. I'm looking for the simplest and most efficient way to > do this. I know, arent we all :) > > Kavita >>> >>> Thanks, >>> Kavita >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
