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 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. > > Thanks. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
