George Mike and Jason Thanks for the ideas! Pete
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Friday, October 20, 2006 11:12 AM To: [email protected] Subject: Re: Query question In a Oracle environment, you could sort the records in the desired order and use ROWNUM.. George On 10/20/06, Mike White <[EMAIL PROTECTED]> wrote: > > You could pick-up NextId from aradmin.arschema, and use it to > reverse-loop through your form, Setting a decrementing NextID by 1, > incrementing a field for each record found - until you get as many as > you want. The last Request ID found would be the first of the last x > record ('sounds like you want 5). Armed with this 5-th-from-last > Request ID, you can select all records greater that it minus 1. > > Just off the top of my head, anyway... > > Mike White > Office: 813-978-2192 > E-mail: [EMAIL PROTECTED] > > > > "Joran, Peter P > CTR OSD CIO" To: [email protected] > <Peter.Joran.ctr@ cc: > OSD.MIL> Subject: Re: Query question > Sent by: "Action > Request System > discussion > list(ARSList)" > <[EMAIL PROTECTED] > ORG> > > > 10/19/2006 14:09 > Please respond to > arslist > > > > > > > I need to put in a Crystal report. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan > Sent: Thursday, October 19, 2006 2:05 PM > To: [email protected] > Subject: Re: Query question > > > How do you want to present the results, probably in a table? In that > case you could sort the records based on the timestamp and limit the > chunk size to 5.. > > George > > On 10/19/06, Joran, Peter P CTR OSD CIO <[EMAIL PROTECTED]> > wrote: > > ** > > > > All > > This seems like a very simple question but I'm stumped. > > How can I return just the oldest 5 records from a query? It's a > > metric that is almost useless but the customer is not budging. > > > > Many Thanks! > > Pete __20060125_______________________This posting was submitted > > with HTML in it___ > > > > ______________________________________________________________________ > ____ > _____ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > ______________________________________________________________________ > _________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > #### smime.p7s has been removed from this note on October 19 2006 by > Michael W. White > > ______________________________________________________________________ > _________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > __________________________________________________________________________ _____ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
smime.p7s
Description: S/MIME cryptographic signature
