Código SQL:
Ver originalCREATE TABLE #temp
(
nombre VARCHAR(20),
ingreso INT,
fecha datetime
)
INSERT INTO #temp VALUES ('Maria',110,'2012-08-05')
INSERT INTO #temp VALUES ('Jose',100,'2012-07-11')
INSERT INTO #temp VALUES ('Maria',110,'2012-07-13')
INSERT INTO #temp VALUES ('juan',90,'2012-07-13')
INSERT INTO #temp VALUES ('juan',100,'2012-07-10')
INSERT INTO #temp VALUES ('juan',85,'2012-08-01')
SELECT * FROM #temp WHERE CONVERT(VARCHAR(20),fecha) + nombre IN
(SELECT CONVERT(VARCHAR(20),MIN(fecha)) + nombre FROM #temp GROUP BY nombre) ORDER BY fecha ASC
Regards!