RE: help with query :)

what about ordering the records by the time stamp ( na column I have for the record creation) and use the ROWCOUNT < 10? will it work?

Thank you all for your responses!
--Yohans

Yohans Mendoza					System Analyst
yohans_at_sirius-images.com			Sirius Images Inc.	
http://www.sirius-images.net/users/yohans    	http://www.sirius-images.com 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On Wed, 31 May 2000 George.Brennan_at_warnermusic.com wrote:

> That will only retrieve the first 10 rows not the last 10 entered. That needs an identifying column, such as a sequence based trigger or auditing.
>
> George,
>
> > -----Original Message-----
> > From: "Abdul Aleem" <abchaudhary-ho_at_beaconhouse.edu.pk>
> > [mailto:abchaudhary-ho_at_beaconhouse.edu.pk]
> > Sent: Wednesday, May 31, 2000 8:59 AM
> > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > 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?
> >
> > TIA
> >
> > --Yohans
> >
> > --
> > Author: Abdul Aleem
> > INET: abchaudhary-ho_at_beaconhouse.edu.pk
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed May 31 2000 - 11:06:46 CDT