Re: Max Record

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Michael Ryan wrote:
> 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!
>   
If the first column is FIELD1 and the second column is FIELD2:

SELECT MAX(FIELD1), FIELD2 from TABLE group by FIELD2

Joe