Begin
SELECT t1.* FROM fidelity t1
  JOIN (SELECT fidId, MAX(fidCurDate)  FROM fidelity GROUP BY date(fidCurDate) order by fidCurDate Desc ) t2
      ON t1.fidId = t2.FidId;
END