Re: Question: Finding the nth row in a table

From: Sadhnani <sadhnani_at_rad.net.id>
Date: 1997/11/27
Message-ID: <347DA617.E4DDBB7D@rad.net.id>#1/1

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:

> Does anyone know that best way to find the nth row in a table?
> I tried to use rowid, but it doesn't seem to work. Is using the
> function chartorowid() the right approach?
>
> Thanks in advance for you help!
>
> Nguyen Nguyen
> ndnguyen_at_ix.netcom.com
>
> BTW, does anyone know a good Oracle SQL book that has
> examples of commonly/useful SQL? Thanks in advance.

--------------9FACB580393ADAE436CD7850
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Naresh Sadhnani
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Naresh Sadhnani
n:              Sadhnani;Naresh
org:            Bakrie Communications Corporation
adr:            Jln. Sunter Mas Barat II,;;H-9 No. 13;Jakarta (Utara);;14350;Indonesia
email;internet: sadhnani_at_rad.net.id
title:          IT Network Advisor
tel;work:       +62-21-9101112 (ext. 226)
tel;fax:        +62-21-6501182
tel;home:       +62-21-6508675

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------9FACB580393ADAE436CD7850-- Received on Thu Nov 27 1997 - 00:00:00 CST