mysql语法问题，哪位能帮我一下，谢谢

Question

SELECT MTAUT_ID,MTAUT_NAME,MTAUT_PARID,MTAUT_INDEX FROM MT005AUT GROUP BY MTAUT_PARID,MTAUT_INDEX DESC

想用group by分组排序
报错，Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mtiansystem.MT005AUT.MTAUT_ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Answer 1

你select里可以查聚合函数（如COUNT, AVERAGE之类的），也可以查询group里的有的列。
但是你“MTAUT_ID , MTAUT_NAME”这两列既不是聚合函数，也不在后面group by里，所以会出错。