select record with maximum value

[arno]

Hello!

I would like to make an sql-query to the following table:
Table:
Field1 Field2
a 1
a 2
a 3
b 6
b 7
c 3
c 4
c 5

The result should be only the record of Field1 that has the maximum value
in Field2 but I do not know how I can do this with an sql-statement:

Result:
Field1 Field2
a 3
b 7
c 5

Thank you

arno

 

[Duane Hookom]

SELECT Field1, Max(Field2) as Max2
FROM tableA
GROUP BY Field1;

 

[arno]

Hi Duane,

thank you, that was just to simple for my twisted brain

arno