On Wed, 26 Nov 2003, Will Leshner wrote:
>Hi. I'm sorry if this is really basic, but I'm wondering if there is a
>way to query a table based on row number and not rowid. In other words,
>I'd like to be able to ask for row number 13 regardless of what its
>rowid might be. I'm happy to write my own
On Nov 26, 2003, at 8:12 PM, William M. Droste wrote:
SELECT * FROM tbl LIMIIT 1 OFFSET 13;
http://www.sqlite.org/lang.html#select
for more info.
Yes. That is exactly what I'm looking for. Thank you very much.
-
To unsubscribe,
SELECT * FROM tbl LIMIIT 1 OFFSET 13;
http://www.sqlite.org/lang.html#select
for more info.
Regards,
Will
On Wed, 2003-11-26 at 13:29, Will Leshner wrote:
> Hi. I'm sorry if this is really basic, but I'm wondering if there is a way to query
> a table based on row number and not rowid. In other
Will Leshner <[EMAIL PROTECTED]> writes:
> Hi. I'm sorry if this is really basic, but I'm wondering if there is a way to
> query a table based on row number and not rowid. In other words, I'd like to
> be able to ask for row number 13 regardless of what its rowid might be. I'm
> happy to write my
Hi. I'm sorry if this is really basic, but I'm wondering if there is a way to query a table based on row number and not rowid. In other words, I'd like to be able to ask for row number 13 regardless of what its rowid might be. I'm happy to write my own function in C if anybody has any suggestions.
5 matches
Mail list logo