SELECT

Name

,RANK() OVER (Partitin By Age ORDER BY Date)

FROM

dbo.Person WITH (NOLOCK);