Re: Retrieve last N rows

Md,
You need to define what the last 10 rows of a table means. Tables are sets of data (called tuples in math language) and an unordered set does not have a last. So you need to specify what last means. For example, if you keep track of when a record is inserted you might want the 10 most recently inserted (or last) records. If you don't keep track of when they were inserted then you can't know which ones they are.

So you really do have to explain what last means to get the last 10 rows.

Jim
"Md Irfan" <irfan_pk_at_hotmail.com> wrote in message news:c42168e7.0205200629.3212246e_at_posting.google.com...
> Daniel Morgan <damorgan_at_exesolutions.com> wrote in message
news:<3CC58103.F426D9B8_at_exesolutions.com>...
> > Md Irfan wrote:
> >
> > > Hi,
> > >
> > > Could any one help me in getting the last N rows from a table? Oracle
7.3.4
> > > Thanks.
> >
> > Only if you can define what the word 'last' means.
>
> Suppose I want the last 10 rows of the table.
> >
> > Daniel Morgan
Received on Mon May 20 2002 - 20:12:26 CDT