2 ms·ya. i use them when I need to delete duplicates and there is no pk.by ryandotsmith 4y agoya. i use them when I need to delete duplicates and there is no pk.hot_gril 4y agoOhh. I always used row_number for that.