Re: "select" simple question?

From: Andrew Babb <andrewb_at_mail.com>
Date: Wed, 24 Mar 1999 09:35:08 +0800
Message-ID: <36F8414C.17B45098@mail.com>

Hi,

rownum is only allocated to rows which have been passed back from the database to the SQL engine, i.e. It's not allocated within the table, just within the SQL query.

Andrew

Manmohan Mann wrote:

> Hi,
>
> Don't recall the technical reasons why, but the only way that rownum can
> be used is with the '<' operator.
>
> So, 'select * from <table name> where rownum < 11' will retrieve the
> first 10 rows.
>
> Manmohan Mann
>
> Jack Zhu 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 Tue Mar 23 1999 - 19:35:08 CST