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

I am trying to formulate an SQL statement that will return a list of records that are distinct on one field, but if a duplicate record (based on the one field) is present with a newer date in the date field, then it should be selected as the "distinct" record.I am trying to formulate an SQL statement that