最大値のレコード取得

SELECT *
FROM T実績 AS A INNER JOIN
(SELECT T実績.日付, Max(日付)
FROM T実績
GROUP BY 主キー) AS B
ON (A.金額 = B.金額) AND (A.日付 = B.日付)