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
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