A table, a field name and MSG, data is as follows:
Zhang: hello, how are you
Li si what day is it today
Fifty and I don't know oh
Li si what you say
Zhang: hello, how are you
Cathy today (Wednesday)
Fifty and I don't know oh


I need to check after get the following data:
Zhang: hello, how are you
Li si what day is it today
Fifty and I don't know oh
Li si what you say
Cathy today (Wednesday)


Don't know the bosses understand not, is the time when the query if you have the same name and MSG, it will not come out, I tried group by name, MSG also not line, specific SQL sayings

CodePudding user response:

Has been solved, is group by name, MSG

CodePudding user response:

Distinct should also can

CodePudding user response:

Both with Max to try