T-SQL 删除重复数据SQL时间:2023-03-09 00:04:09 WITH cte AS ( SELECT roleid,permissionid, row_number() OVER(PARTITION BY roleid,permissionid ORDER BY roleid,permissionid) AS [rn] FROM rolepermissionrecords ) DELETE cte WHERE [rn] > 1