/****** Script for SelectTopNRows command from SSMS ******/
with tmp as (
SELECT
[userID]
,[centerID]
, row_number()over(partition by userID
,centerID order by [userID]
,[centerID]) rowno
from [DBATools].[dbo].[ludingtest2]
)
delete from tmp where rowno >1
select * from [DBATools].[dbo].[ludingtest2]