Hei,
Try the following sql statements:
To get the first n rows : SELECT * FROM <table-name> LIMIT <n> OFFSET 0
To get the nth entry : SELECT * FROM <table-name> LIMIT 1 OFFSET <n-1>
Suresh
Kavita Raghunathan 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 ?
>
>
> Thanks,
> Kavita
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Nth-row-of-on-sqlite-DB-tp29963848p31002137.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
