Hello cooljagadeesh,

You can implement RANK in your query like this

select *,

RANK() over (partition by name order by row) as rank

from @table

also for your filter purpose, the query is

select * from

(

select *,RANK() over (partition by name order by row) as rank from @table

) temp where rank =3

Thanks....:-)