This is some of the data, how can I get the red box of the duplicate data delete, leaving only a data?

CodePudding user response:

You can use the ROW_NUMBER () OVER (partition by) or group by having