Re: SQL Question

[Alan Shore <AlanShore@xxxxxxxx>]

Assuming the date field is numeric (and NOT defined as DATE)I think its
something like this

select Division, Account, PO#, min(dec(digits(Date Changed Century  1/0) ||
digits(Date Changed YYMMDD)))

I think
therefore I am
I think



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/01/2006 02:13:23 PM:

> I have a history file with the following fields :
> Division
> Account
> PO#
> Date Changed YYMMDD
> Date Changed Century  1/0
> Cancel Date
>  Old / New Code  O/N
> .
> .
> .
> .
>
> Is there a way using SQL to select the data from the record with the
> oldest date for a given Division, Account & PO#.
>
> TIA,
>
> Jeff Young
> Sr. Programmer Analyst
> Dynax Solutions, Inc.
> A wholly owned subsidiary of enherent Corp.
> IBM -e(logo) server Certified Systems Exper - iSeries Technical
> Solutions V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical
> Solutions Designer V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical
> Solutions Implementer V5R3
____________________________________________________________________________________

> Cheap talk?
> Check out Yahoo! Messenger's low PC-to-Phone call rates.
> http://voice.yahoo.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.