Would Select * From Product order by ProductName LIMIT 1 OFFSET 209
help? -- Igor Piyush Verma-3 wrote: > > 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 > > -- View this message in context: http://old.nabble.com/Retrieve-Specific-record-number-in-one-shot.-tp29115356p29115896.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