Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question: Finding the nth row in a table
In article <65cga4$ifr$2_at_news1.rmi.net>
ndnguyen_at_ix.netcom.com (Nguyen Nguyen) writes:
> Does anyone know that best way to find the nth row in a table?
The rows in a relational database aren't ordered, so if you want the Nth row, you have to define your own ordering. For example, you might add a column with a value that's increased by 1 for each row inserted.
Tim Received on Tue Nov 25 1997 - 00:00:00 CST