Row number within an SQLSERVER

declare @test table (ChecklistTypeID
 int, HeaderDescription
 varchar(50),SubHeaderDescription varchar(50));

insert into @test values('1960','Sampling/Audit','Leases/Tenant Info Changes');
insert into @test values('1960','Sampling/Audit','Leases/Tenant Info Changes');
insert into @test values('2163','Sampling/Audit','Military Customer');
insert into @test values('2164','Sampling/Audit','Military Customer');
insert into @test values('2165','Sampling/Audit','Military Customer');

select ChecklistTypeID, HeaderDescription,SubHeaderDescription,
row_number() over(partition by SubHeaderDescription order by ChecklistTypeID ASC) as mySelection
 from @test
order by ChecklistTypeID desc


select *, ROW_NUMBER() OVER(partition by HeaderDescription order by mySelection  ) as myRanking from #Temp1
order by ChecklistTypeID desc, HeaderDescription