Cita:
Iniciado por Libras 
y asi:
Código SQL:
Ver originalCREATE TABLE #temp
(
dato datetime
)
INSERT INTO #temp VALUES ('2011-06-07')
INSERT INTO #temp VALUES ('2011-06-07')
INSERT INTO #temp VALUES ('2011-06-12')
INSERT INTO #temp VALUES ('2011-06-14')
INSERT INTO #temp VALUES ('2010-01-12')
SELECT * FROM(
SELECT ROW_NUMBER() OVER(ORDER BY dato DESC) rn, dato FROM #temp
) AS t1 WHERE rn=2
Esa es la manera
gracias colega que tengas buen día