;WITH sampledata AS

(

SELECT * FROM

(VALUES

(1,'2013-01-01','fred'),

(2,'2013-01-05','ralph'),

(3,'2012-12-31','jane'),

(4,'2012-12-15','suzie')

) DATA (ID,EndDate,Name))

,

cteRank AS

(

SELECT

--RANK() OVER (ORDER BY EndDate DESC) AS [Rank]

RANK() OVER (ORDER BY EndDate DESC, ID DESC) AS [Rank] -- edited to add a tie-breaker

,ID

,EndDate

,Name

FROM

sampledata

)

SELECT

*

FROM

cteRank c1

CROSS APPLY

cteRank c2

WHERE

c1.[Rank] = 1

AND c2.[Rank] = 2