At 3:00 PM -0700 10/7/07, Adam Megacz 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".
SELECT * FROM table LIMIT 120 OFFSET 100;
http://sqlite.org/lang_select.html
"The LIMIT clause places an upper bound on the number of rows
returned in the result. A negative LIMIT indicates no upper bound.
The optional OFFSET following LIMIT specifies how many rows to skip
at the beginning of the result set. In a compound query, the LIMIT
clause may only appear on the final SELECT statement. The limit is
applied to the entire query not to the individual SELECT statement to
which it is attached."
-pmb
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------