RE: Max Record

["Wilt, Charles" <WiltC@xxxxxxxxxx>]

Given
Fld1        Fld2
5,769,550   247746
6,025,776   247746
6,025,777   247746
6,025,778   247746
6,004,452   257503
6,004,457   257503
5,986,723   279287
5,986,724   279287
5,986,725   279287
5,986,042   279369
5,986,049   279369
5,986,052   279369


Select fld2, max(fld1)
From myfile
Group by fld2

HTH,

Charles Wilt 
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx


> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
> Sent: Wednesday, June 25, 2008 12:21 PM
> To: Midrange Systems Technical Discussion
> Subject: Max Record
>
> I can't seem to get this right. Given data that looks like this:
>
> 5,769,550   247746
> 6,025,776   247746
> 6,025,777   247746
> 6,025,778   247746
> 6,004,452   257503
> 6,004,457   257503
> 5,986,723   279287
> 5,986,724   279287
> 5,986,725   279287
> 5,986,042   279369
> 5,986,049   279369
> 5,986,052   279369
>
> How can I get the record with the largest first value in SQL? I want this:
>
> 6,025,778   247746
> 6,004,457   257503
> 5,986,725   279287
> 5,986,052   279369
>
> Thanks!
> --
> 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 e-mail transmission contains information that is intended to be confidential and privileged.  If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful.  Please reply to the message immediately by informing the sender that the message was misdirected.  After replying, please delete and otherwise erase it and any attachments from your computer system.  Your assistance in correcting this error is appreciated.