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....:-)