[SQL]查詢重覆資料日期最大的資料

  SELECT * FROM IFGAA50FD80 AS A
  WHERE A.MTDT =
  (SELECT MAX(MTDT) FROM IFGAA50FD80
  AS B  WHERE A.IFGAA50FD80002 = B.IFGAA50FD80002
  )