This is the SQL:
This is an error picture:

What's going on

CodePudding user response:

Why do you want to add group by, there is no meaning ah,
If stubbornly plus group by, group by, please select the back all of the fields, remove the field alias, remove the aggregation function (no) in your SQL

CodePudding user response:

Group by only with aggregate functions with
You use ATTRIBUTE_ID group to other fields, and can only be used as the count, min, Max these aggregation function
And no direct query such as CREATETIME these fields