In aggregated query without group by, expression 1 of select list contains nonaggregated column

sql Statement error content ：

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'sw_promanage.a.id'; this is incompatible with sql_mode=only_full_group_by

Error reason ：

MySQL Version of the problem , Some versions are enabled by default ONLY_FULL_GROUP_BY, So it led to some SQL Unable to execute normally , Because group by after , Some of the data returned is indeterminate , That's why this error occurs .

resolvent （ Two kinds of ）：

• （1） Use ANY_VALUE(column_name).

for example ：
Error code ：

SELECT 
	a.id AS "id",
	a.project_id AS "projectId",
	sum(a.reward_money) AS "rewardMoney",
	sum(a.punish_money) AS "punishMoney"
FROM pm_reward_punishment_plan a
where a.project_id = 'xxxxxxxx'

Modified code ：

SELECT 
	ANY_VALUE(a.id) AS "id",
	a.project_id AS "projectId",
	sum(a.reward_money) AS "rewardMoney",
	sum(a.punish_money) AS "punishMoney"
FROM pm_reward_punishment_plan a
where a.project_id = 'xxxxxxxx'

• (2) Set up the database , close ONLY_FULL_GROUP_BY.

edit my.cnf file , find sql-mode The location of , Get rid of ONLY_FULL_GROUP_BY, restart MySQL service ;
Such as my.cnf There is no sql-mode, You need to add the following ：
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION, restart MySQL service .