group by
having
max
参考:https://blog.51cto.com/u_16213600/6983022
参考2:https://www.cnblogs.com/2008nmj/p/16628913.html
SELECT xxx,min(bbb) FROM "table1" group by xxx
参考3:https://www.cnblogs.com/chenqingbin/p/13408688.html(SQL 分组后获取其中一个字段最大值的整条记录)
group by
having
max
参考:https://blog.51cto.com/u_16213600/6983022
参考2:https://www.cnblogs.com/2008nmj/p/16628913.html
SELECT xxx,min(bbb) FROM "table1" group by xxx
参考3:https://www.cnblogs.com/chenqingbin/p/13408688.html(SQL 分组后获取其中一个字段最大值的整条记录)