Advertisement
Guest User

Untitled

a guest
Jan 27th, 2020
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. WITH CTE AS
  2. (
  3. SELECT *,ROW_NUMBER() OVER (PARTITION BY order_hash ORDER BY order_hash) AS RN
  4. FROM [dbo].[DmN_Donate_MercadoPago_Transactions]
  5. )
  6.  
  7. DELETE FROM CTE WHERE RN<>1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement