我的github

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 分组后获取其中一个字段最大值的整条记录)

posted on 2024-01-12 10:56  XiaoNiuFeiTian  阅读(4)  评论(0编辑  收藏  举报