要用子查询,如
语句1:select 第一列, min(日期) as 日期 from {表A} group by 第一列
语句2:select * from {表A} as a inner join (语句1) as b on a.第一列 = b.第一列 and a.日期 = b.日期