SQLServerCentral » Latest topics
Need to get consecutive duplicate rows
I need a query that can get me (the ID of) consecutive duplicate rows, where I am grouping on some of the columns, don't care about rest.
I know I have to use row over to look for consecutive, and group by certain columns that make the dupe
I know I have to use row over to look for consecutive, and group by certain columns that make the dupe
No comments:
Post a Comment