Hello, everyone, now have to table 1, table 1 of color that part of the data is normal data, but for some reason, this part of the data is repeated 1 time, now I want to make table 1 and table 2, please answer (note that there are colors that part of the data, originally has repeated itself, so ordinary group by useless)

CodePudding user response:

Of course, you want to increase the incremental ID, then group by field 1 + 2 and then having the count...