随笔分类 -  Mysql

[Error fix] Incorrect date value: '0000-00-00'
摘要：SELECT @@sql_mode; = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUB 阅读全文
posted @ 2022-10-18 16:19 大漠孤烟~ 阅读(20) 评论(0) 推荐(0)
Mysql获取每个班前三名的学生
摘要：如图上面是数据： 正确解法(假设分数一样则名次一样) SELECT * FROM student t WHERE (SELECT COUNT(1)+1 FROM student WHERE class_id=t.class_id AND grade>t.grade)<=3 运行结果： 错误解法：来源 阅读全文
posted @ 2021-05-15 23:03 大漠孤烟~ 阅读(387) 评论(0) 推荐(0)