Pictured below is my table. I had to use a multi step query to extend out all my sub numbers. Now I need to remove all the rows that lead up to the last row.
For Example 1637276M1 through 1637276M6 should be deleted and 1637276M7 should be kept with all the sub number to the right of it.
How could i delete those rows?