Re: [sqlite] Retrieve Specific record number in one shot.

On Fri, Jul 09, 2010 at 08:12:20AM -0300, Israel Lins Albuquerque scratched on the wall: > Maybe do you want this! > > http://www.sqlite.org/syntaxdiagrams.html#select-stmt > > Select * From Product order by ProductName LIMIT 210 OFFSET 210; Close, but not quite. This will return rows

Re: [sqlite] Retrieve Specific record number in one shot.

Piyush Verma wrote: > I want to navigate to specific position in table for example I want > row number 210 inspite of nevigating one by one how can get that row. See if this helps: http://www.sqlite.org/cvstrac/wiki/wiki?p=ScrollingCursor -- Igor Tandetnik

Re: [sqlite] Retrieve Specific record number in one shot.

Maybe do you want this! http://www.sqlite.org/syntaxdiagrams.html#select-stmt Select * From Product order by ProductName LIMIT 210 OFFSET 210; - "Piyush Verma" escreveu: > Hello All, > > I want to navigate to specific position in table for example I want > row

[sqlite] Retrieve Specific record number in one shot.

Hello All, I want to navigate to specific position in table for example I want row number 210 inspite of nevigating one by one how can get that row. One way could be create a Index and use where clause to get that But it's not useful in my case. I have table which have primary key, and product