delete duplicate records in TSQL

select * from T.Tbl_Index b
where (select count(*) from T.Tbl_Index a where a.name>b.name)=5
order by name desc