rownumber over by

 select *,

ROW_NUMBER() Over (PARTITION  by ColumnType order by ColumnType desc ) as rn

from [NH].[tbl_NewHire_LookupValues]  where countryCode='AE'

i have duplicate dropdown values entered remove it from the list 

by using above code not getting row number properly