deleting rows based on row_num
In my CTE, i find out the duplicates. Then, through the SELECT statement and row_number, I decided which rows I want to delete.
In my CTE, i find out the duplicates. Then, through the SELECT statement and row_number, I decided which rows I want to delete.