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" <piyush...@gmail.com> escreveu: > 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 name(there is another > index for ProductName). Now I sort by Product name and want to access > row number 210. > > Is that a way to get it directly? > > like > > >>"Select * From Product order by ProductName" > >>move_to_row(210); > >>read row; > > > something like that. > > > > > -- > Thanks & Regards > > Piyush Verma > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users