Re: "select" simple question?

From: dreft <dreft_at_aol.com>
Date: 24 Mar 1999 08:31:04 -0600
Message-ID: <VF6K2.4216$gn1.12730@newscene.newscene.com>

You need to specify what is meant by the 'first 10 rows'. Oracle doesn't store rows in a sorted order so the literal first 10 rows in a table will not be in specific order.

You need to tell oracle via SQL what order you desire the fields in.

If by the 'first 10 rows' you mean the first 10 pieces of info that oracle proscessed, then you would need some timestamp down to sec or less to determine the order of processing.

In article <7d990t$2qr$1_at_news.monmouth.com>, "Jack Zhu" <jackzhu_at_monmouth.com> wrote:
>How can I use "select" to retrive first 10 rows of a table?
>
>Thanks in advance!
>
>Pls email me!
>
>jackzhu_at_monmouth.com
>
>
Received on Wed Mar 24 1999 - 08:31:04 CST