SELECT DISTINCT
c.Nombre,
(select ciudad from Clientes as x where x.nombre=c.nombre and x.FechaDeAct = (select max(FechaDeAct) from Clientes as t where t.Nombre=c.nombre)) AS Ciudad,
(select telefono from Clientes as x where x.nombre=c.nombre and x.FechaDeAct = (select max(FechaDeAct) from Clientes as t where t.Nombre=c.nombre)) AS Telefono,
(select max(FechaDeAct) from Clientes as t where t.Nombre=c.nombre) AS FechaDeAct
FROM Clientes AS c;
SELECT
c.Nombre,
(select ciudad from Clientes t where t.nombre=c.nombre and t.FechaDeAct = (select max(FechaDeAct) from Clientes as x where x.Nombre=c.Nombre) ) as Ciudad,
(select telefono from Clientes t where t.nombre=c.nombre and t.FechaDeAct = (select max(FechaDeAct) from Clientes as x where x.Nombre=c.Nombre) ) as Telefono,
Max(c.FechaDeAct) AS UltFechaDeAct
FROM Clientes AS c
GROUP BY c.Nombre;