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
