delete duplicate by keeping original

deleteduplicate.cs

WITH CTE AS
(
	SELECT *
		   ,ROW_NUMBER() OVER 
		   (
				PARTITION BY [CreditVerifierRoleId],[CreditRuleJobGroupId],[CreditGrade],[SalaryRate],[AveragingRate],[AveragingMonthDuration],[MaxCredit],[MaxGuaranteePerCustomer],[CreditRuleType],[BeginDate],[EndDate],[CreatedOn],[CreatedBy],[ModifiedOn],[ModifiedBy] 
				ORDER BY [CreditVerifierRoleId],[CreditRuleJobGroupId],[CreditGrade],[SalaryRate],[AveragingRate],[AveragingMonthDuration],[MaxCredit],[MaxGuaranteePerCustomer],[CreditRuleType],[BeginDate],[EndDate],[CreatedOn],[CreatedBy],[ModifiedOn],[ModifiedBy]
		   ) AS RN
	FROM [QTasBankDatabase].[Loan].[CreditRules]
)

DELETE FROM CTE WHERE RN<>1