Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieve last N rows
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<_9hG8.67964$UV4.87535_at_rwcrnsc54>...
> 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,
We have table that does not contain date column. So normally some 50
rows are inserted to this table daily. Just I want to see the last 50
rows.
Received on Tue May 21 2002 - 08:11:35 CDT
![]() |
![]() |