Re: Last n rows from a table

How?

I am newbie in Oracle, so that i'd like to also know effective way how to:

• get number of rows which an select produces
• fetch specified limit of rows without need to fetch unneeded rows

Can someone help me?

"Steve Long" <steven.long_at_erols.com> wrote in message news:8tr8f6$9jj$1_at_bob.news.rcn.net...
> yes, it is possible.
>
> <sashid99_at_my-deja.com> wrote in message
 news:8tr3ma$f8p$1_at_nnrp1.deja.com...
> > I'd like to retrieve the last 20 rows from a
> > table, if the table has more than 20 rows.
> >
> > Is that possible?
> >
> > Thanks in Advance.
> > Sashi
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Thu Nov 02 2000 - 03:49:40 CST