select * from table limit (n-1),(m-n) n-1 because it is 0-based
http://www.sqlite.org/lang_select.html On 10/8/07, Adam Megacz <[EMAIL PROTECTED]> wrote: > > Hello. This is probably a stupid question, but... > > Is there any way to include some phrase in a SELECT clause that will > match only the Nth-Mth rows of a table, for some values of N and M? > > Note that ROWID isn't what I'm looking for -- if you delete rows from > a table the ROWID no longer matches the "row number". > > Thanks, > > - a > > -- > PGP/GPG: 5C9F F366 C9CF 2145 E770 B1B8 EFB1 462D A146 C380 > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------