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 211
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
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 number 210 inspite of
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 n
4 matches
Mail list logo