mysql单表、多表查询与group by 查询最大最小值避坑指南

小雨天的树荫

于 2022-08-10 17:07:51 发布

阅读量430

点赞数 2

分类专栏： mysql 文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/baidu_28291037/article/details/126269295

版权

关于mysql的操作，各大博主都贡献了特别多的笔记，在这里我们只谈经验。

背景：有如下一张student表和一张course表

mysql> select * from student;
+----+----------+------+-------+------------+---------------------+--------+
| id | name     | age  | score | birthday   | insert_time         | course |
+----+----------+------+-------+------------+---------------------+--------+
|  1 | zhangya  |   15 |  98.0 | 2007-01-27 | 2022-08-10 16:30:57 | 2      |
|  2 | alice    |   14 |  60.0 | 2008-08-08 | 2022-08-10 13:28:42 | 1      |
|  3 | zhangsan |   17 |  89.0 | 2005-11-30 | 2022-08-10 14:12:58 | 3      |
|  4 | lisi     |   15 |  70.0 | 2007-11-05 | 2022-08-10 14:07:53 | 2      |
|  5 | wangwu   |   15 |  90.0 | 2007-05-18 | 2022-08-10 11:58:23 | 1      |
|  6 | wangwu   |   15 |  98.0 | 2007-05-18 | 2022-08-10 21:27:51 | 2      |
|  7 | wangwu   |   15 |  70.0 | 2007-05-18 | 2022-08-10 21:27:51 | 3      |
|  8 | lisi     |   15 | 100.0 | 2007-11-05 | 2022-08-10 14:07:53 | 3      |
|  9 | lisi     |   15 |  50.0 | 2007-11-05 | 2022-08-10 14:07:53 | 1      |
| 10 | zhangsan |   18 |  89.0 | 2007-05-18 | 2022-08-10 14:03:26 | 1      |
| 11 | zhangsan |   15 |  60.0 | 2007-05-18 | 2022-08-10 21:27:51 | 2      |
| 12 | alice    |   14 |  49.0 | 2