执行SQL:
SELECT login_name,login_ip,sex FROM tank_admin GROUP BY login_name ;
时抛出异常。
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'loser.tank_admin...
解决MySQL报错:1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat
转自:https://blog.csdn.net/HaHa_Sir/article/details/80503601
2018年05月29日 23:10:52 ...
1、先看错误的sql语句:
select a.authName from roles as r,authority as a,role_ah as ra where ra.roleId=r.roleId and ra.ahId=a.ahId and roleId='R002'
2、再看正确的sql语句:
select a.authName from ro...