摘要：select @@GLOBAL.sql_mode; set global sql_mode=`STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION` htt 阅读全文

摘要：https://blog.csdn.net/pippa134679/article/details/81354131 阅读全文

摘要：分组rank: 转载：https://blog.csdn.net/u011726005/article/details/94592866 分组不rank取前几：https://www.jianshu.com/p/cbb4706785e7 阅读全文

摘要：//待测试 https://blog.csdn.net/weixin_34217773/article/details/88165450 阅读全文

摘要：MySQL中实现rank排名查: https://blog.csdn.net/justry_deng/article/details/80597916 每个学院每条记录的刷卡时间排名（千万级） 5.7： SELECT t.academy,@curRank := @curRank + 1 AS ran 阅读全文