mysq查询all和 any的用法

今天药忘吃喽~ 2023-10-06 20:14 18阅读 0赞

#### All ####

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

#### Any ####

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

any表示有任何一个满足就返回true，all表示全部都满足才返回true
    **感觉这句很清楚
    
    比如
    select * from student where 班级=’01’ and age > all (select age from student where 班级=’02’);
    就是说，查询出01班中，年龄大于 02班所有人的同学
    相当于
    select * from student where 班级=’01’ and age > (select max(age) from student where 班级=’02’);
    
    而
    select * from student where 班级=’01’ and age > any (select age from student where 班级=’02’);
    就是说，查询出01班中，年龄大于 02班任意一个 的 同学
    相当于
    select * from student where 班级=’01’ and age > (select min(age) from student where 班级=’02’);

参考：[https://www.yiibai.com/sql/sql-all.html][https_www.yiibai.com_sql_sql-all.html]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5LiN56ev6Les5q2l77yM5peg5Lul6Ie05Y2D6YeM_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/ce80b2f67e7049a2bdaa00b75c4cd675.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5LiN56ev6Les5q2l77yM5peg5Lul6Ie05Y2D6YeM,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5LiN56ev6Les5q2l77yM5peg5Lul6Ie05Y2D6YeM_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/ff95f33d526e483289d8c5d2aede9d57.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5LiN56ev6Les5q2l77yM5peg5Lul6Ie05Y2D6YeM,size_20,color_FFFFFF,t_70,g_se,x_16
[https_www.yiibai.com_sql_sql-all.html]: https://www.yiibai.com/sql/sql-all.html