SELECT id,visits FROM `zentao`.`zt_user`
SELECT id,max(visits) FROM `zentao`.`zt_user`
如下图：结果查出的id不是max对应的id
应该改为
SELECT id,visits FROM `zentao`.`zt_user` where visits = (SELECT max(visits) FROM `zentao`.`zt_user`) limit 1 SELECT id,visits FROM `zentao`.`zt_user` order by visits desc limit 1
原文：https://www.cnblogs.com/-mrl/p/13098329.html