Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: help with query :)
I don't think this will do the trick. Won't this just pick the first 9
records out of the query ?
If there's no field in the table storing date/time of insert, I don't think
there's a way of doing this.
Greets
> -----Original Message-----
> From: Abdul Aleem [SMTP:abchaudhary-ho_at_beaconhouse.edu.pk]
> Sent: Wednesday, May 31, 2000 8:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: help with query :)
>
> In your WHERE clause try adding ROWCOUNT < 10;
>
> Regards,
>
> Aleem
>
> -----Original Message-----
> From: Yohans Mendoza
> [mailto:yohans_at_demiurge.sirius-images.net]
> <mailto:[mailto:yohans_at_demiurge.sirius-images.net]>
> Sent: 31 May, 2000 5:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: help with query :)
>
> hi all,
>
> hope you're ok
> I have this "silly" question. Is there an easy way to
> retrieve the last 10
> records that have been entered in a given table?
>
Received on Wed May 31 2000 - 03:56:11 CDT
![]() |
![]() |