Consistent for the same customer name, type, number, this kind of circumstance how to realize the SQL group, the redistribution of the same customer number

CodePudding user response:

What is the result you want? Use excel,

CodePudding user response:

The result is like this to allocate the same serial number

CodePudding user response:

reference 1st floor selling fruit net reply:

the results you want is what kind of? Use excel,

is this result downstairs, I already have a method, is more complex, you see if there are any simple method to implement the function

CodePudding user response:

'E00000' | | dense_rank () over (partition by a, b)