Re: SQL Question

[Alan Shore <AlanShore@xxxxxxxx>]

Sorry Jeff - I just re-read what you asked for

when you said oldest date, do you mean earliest or latest?



Alan Shore

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


                                                                       
             Alan Shore                                                
             <AlanShore@xxxxxx                                         
             om>                                                        To
             Sent by:                  Midrange Systems Technical      
             midrange-l-bounce         Discussion                      
             s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>       
                                                                        cc
                                                                       
             12/01/2006 02:31                                      Subject
             PM                        Re: SQL Question                
                                                                       
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       




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.
--
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.