Problema En Consulta

[GeriReshef]

Yo utilizaria el Row Number:

Código SQL:

WITH T AS
(SELECT *,
    ROW_NUMBER() OVER(Partition BY Cliente ORDER BY Fecha DESC) Nm
FROM MiTabla)
SELECT *
FROM T
WHERE Nm=1;