Find and Delete Duplicate Rows From a Table in SQL Server

WITH CTE AS(

   SELECT *,     

   RN = ROW_NUMBER()OVER(PARTITION BY OrderID ORDER BY OrderID)

   FROM tbl_Order  

)

SELECT * FROM CTE WHERE RN >1

DELETE   FROM CTE WHERE RN >1