I use a connector to connect the three fields and then go to heavy, but when I added above the winning red field, to the statements in the records query, often a duplicate records and didn't add the fields to query the records are not repeated, seek the solution!!!!!

CodePudding user response:

Go back behind all the columns, not in the parentheses

CodePudding user response:

Distict is to remove duplicate records in the SELECT field, is not the first column, Row_number () over sort (), take the first

CodePudding user response:

refer to the second floor qq_42654471 response:

distict is to remove duplicate records in the SELECT field, is not the first column, Row_number () over (), take the first

thank you

CodePudding user response:

There is distinct in front, so behind the field more or change, are likely to cause the change of the results,