Home > database > I would like to screen out the adjacent repeat 3 times and above data, could you tell me how to get,
I would like to screen out the adjacent repeat 3 times and above data, could you tell me how to get,
Time:10-01
As shown in figure, probably doing this is a standard, but my database, the time of this field is string, I want to screen out zhang SAN in 11-13 consecutive duplicate data, and li si 9-12 repeat four times the data, please help thank you