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 <347DA617.E4DDBB7D_at_rad.net.id>, sadhnani_at_rad.net.id wrote:
>This is a multi-part message in MIME format.
>--------------9FACB580393ADAE436CD7850
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Dear Nguyen,
>
> Try select * from <tablename> where rownum = <n>
>
>Naresh
>
>Nguyen Nguyen wrote:
>
Wow - After all of the debate in this thread, someone still posts the "solution" that caused the controversy in the first place...
.:'`':..:'`':.. Andre T. Allen ..:'`':..:'`':. | Disclaimer: | | andre_at_interaccess.com | | All opinions | | Systems Admin/Oracle 7 DBA/MS-SQL Server DBA | | expressed are | +---------- Reid Psychological Systems --------+ | my own. |Received on Sun Nov 30 1997 - 00:00:00 CST