2019年10月23日
数据库多表连接查询中使用group by分组语句，Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX' which is not functionally dependent on columns in GROUP BY claus
摘要： 需求描述： 要是用两表联合查询，并对查询的结果进行分组：sql如下： 这样的sql语句会报错结果如下： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.id' wh 阅读全文
posted @ 2019-10-23 10:06 Java_lively 阅读(1554) 评论(0) 推荐(0) 编辑