It _shuldn't_ work, because ROWNUM works before order by, not after.
Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant
----- Original Message -----
From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, June 02, 2000 4:44 PM
Subject: RE: help with query :)
> I think excellent, It should work.
>
> -----Original Message-----
> From: Yohans Mendoza
> [mailto:yohans_at_demiurge.sirius-images.net]
> Sent: 31 May, 2000 10:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> > also send the HELP command for other information (like
> subscribing).
> >
>
> --
> Author: Yohans Mendoza
> INET: yohans_at_demiurge.sirius-images.net
>
> 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: 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
Received on Fri Jun 02 2000 - 03:15:00 CDT
