deleting duplicates

WITH CTE (sales_transaction_id, DuplicateCount)


AS

(

SELECT sales_transaction_id,

ROW_NUMBER() OVER(PARTITION BY sales_transaction_id ORDER BY sales_transaction_id) AS DuplicateCount

FROM fda_rpt..stg_rpt_location

)

DELETE

FROM CTE

WHERE DuplicateCount > 1

GO