我需要基于一个字段和日期的DISTINCT记录列表

Field 1  Field 2  Field 3
A        3/28/11  Jimmy
A        4/11/11  Tom
B        3/29/11  Harry
C        4/12/11  Tom
C        3/30/11  Jimmy

A        4/11/11  Tom
B        3/29/11  Harry
C        4/12/11  Tom

SELECT A.Field1, A.Field2, A.Field3
FROM myTable A
INNER JOIN (
    SELECT B.Field1, MAX(B.Field2) AS MaxDate
    FROM myTable B
    GROUP BY B.Field1) AS B
        ON A.Field1 = B.Field1 AND A.Field2 = B.MaxDate
ORDER BY A.Field1