mysql常考点

红太狼 2022-10-13 05:13 161阅读 0赞

## 1、limit ##

[详情连接][Link 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70]

## 2、去重 distinct ##

[详情连接][Link 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 1]

## 3、between and ##

[详情][Link 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 2]

## 4、嵌套查询 ##

[详情][Link 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 3]

## 5、左连接，右连接 ##

[详情][Link 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 4]

## 6、分组 grop by … having ##

[详情][Link 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 5]

## 7、倒序 order by （一般和limit共用 取前几名） desc（加desc 是倒序，不加是顺序） ##

[详情][Link 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 6]

## 8、count、sum、avg ##

## sql经典面试题 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70_pic_center]

https://blog.csdn.net/yeewingho/article/details/106161280?utm\_source=app&app\_version=4.9.3&code=app\_1562916241&uLinkId=usr1mkqgl919blen

[Link 1]: https://blog.csdn.net/lanyang123456/article/details/57522471?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555214816780274169137%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555214816780274169137&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-57522471.pc_search_result_control_group&utm_term=mysql%20limit&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70]: /images/20221005/545fc26aea4146f09d21489b08baa1e4.png
[Link 2]: https://blog.csdn.net/zhangzehai2234/article/details/88361586?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555275616780265442335%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555275616780265442335&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-88361586.pc_search_result_control_group&utm_term=mysql%E7%9A%84distinct%E7%94%A8%E6%B3%95&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 1]: /images/20221005/8a25a416d13a41b6ad946bc89fe76d11.png
[Link 3]: https://blog.csdn.net/qq_31625935/article/details/89017212?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555311316780269865062%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555311316780269865062&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-89017212.pc_search_result_control_group&utm_term=mysql%20between%20and%20&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 2]: /images/20221005/0f4fed0c7b224135939836b9403ca47c.png
[Link 4]: https://blog.csdn.net/m0_38061639/article/details/82872705?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555306916780264082747%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555306916780264082747&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-2-82872705.pc_search_result_control_group&utm_term=mysql%20%E5%B5%8C%E5%A5%97%E6%9F%A5%E8%AF%A2&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 3]: /images/20221005/fd590e44ea0847ee8c54d5dade0fce72.png
[Link 5]: https://blog.csdn.net/plg17/article/details/78758593?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555301716780269814267%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555301716780269814267&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-78758593.pc_search_result_control_group&utm_term=mysql%E5%B7%A6%E8%BF%9E%E6%8E%A5%E5%8F%B3%E8%BF%9E%E6%8E%A5&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 4]: /images/20221005/188e0d7b03314fdb839b0946fe19778f.png
[Link 6]: https://blog.csdn.net/hjwang1/article/details/7270921?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162554416316780264080358%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162554416316780264080358&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-7270921.pc_search_result_control_group&utm_term=mysql%20group%20by&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 5]: /images/20221005/c1bb8951905e4c458a502f8fa2bb3c99.png
[Link 7]: https://blog.csdn.net/u011277123/article/details/78913361?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162555253216780262575333%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162555253216780262575333&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-2-78913361.pc_search_result_control_group&utm_term=mysql%E7%9A%84order%20by%E7%94%A8%E6%B3%95&spm=1018.2226.3001.4187
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70 6]: /images/20221005/367ec7a351df400697f203ba48947a25.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTY2NTYzNw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221005/51a99088a8e74f72b0bda66413514338.png