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 through 420.

  If you want row 210, you need "LIMIT 1 OFFSET 209".  Or "LIMIT 209, 1"


Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
sqlite-users mailing list

Reply via email to