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]
-----------------------------------------------------------------------------

Reply via email to