Código SQL:
Ver originalCREATE TABLE #temp
(
rut VARCHAR(20),
nombre VARCHAR(20),
fecha datetime
)
INSERT INTO #temp VALUES ('11111111-1','juan','05-05-2014')
INSERT INTO #temp VALUES ('11111111-1','juan','06-06-2014')
SELECT t1.* FROM #temp AS t1
LEFT JOIN (SELECT MAX(fecha) AS fecha,rut,nombre FROM #temp GROUP BY rut,nombre) AS t2 ON (t1.rut=t2.rut AND t1.fecha=t2.fecha)
WHERE t2.fecha IS NOT NULL
saludos!