Do not use the Max function, there are other possible ways: no, thank you for the great spirit

CodePudding user response:

Select the list of fields must appear in the group by clause, this is not going to move...

CodePudding user response:

After the group by, or treated with aggregation function, there is no it

PS: the original poster should be in MySQL often don't write after the group by,

CodePudding user response:

Max (field) over (partition by field)

CodePudding user response:

Wm_concat try

CodePudding user response:

This is an important characteristic of ORACLE, if use the GROUP BY then, after the SELECT content, if not, after the GROUP BY aggregation function must be used, or directly to the constants can also,