Re: Selecting a specific row

"Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com> writes:

> Is there an easy way to select, say, the 15th row in a table? I can't
> use a sequence number because rows will sometimes be deleted resulting
> in the 15th row now being a different row. I need to be able to select
> the 15th row regardless of whether it is the same 15th row as the last
> select.

You can use LIMIT and OFFSET in your SELECT for this, but bear in mind
that rows are not stored in any guaranteed order, so use ORDER BY if
you need to.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863