Posts by Allex MeneZes • 191 points
1 post
-
9
votes5
answers7016
viewsA: How to delete all duplicates except one?
In a simpler and more practical way: I hope to help you with cte as ( select usuario_id , row_number () over ( partition by usuario_id order by usuario_id ) as r from creditos where status = 0 )…