举例:
mysql> select goods_id,goods_price from tdb_goods where goods_price > any(select goods_price from tdb_goods where goods_cate='超级本');
mysql> select goods_id,goods_price from tdb_goods where goods_price > any(select goods_price from tdb_goods where goods_cate='超级本');
2015-08-10
子查询返回多个结果时:
用any some all 修饰的比较运算符
---------------
operand comparison_operatro any(subquery)
运算符 any some all
> >= 最小值 最小值 最大值
< <= 最大值 最大值 最小值
= 任意值 任意值
<> != 任意值
用any some all 修饰的比较运算符
---------------
operand comparison_operatro any(subquery)
运算符 any some all
> >= 最小值 最小值 最大值
< <= 最大值 最大值 最小值
= 任意值 任意值
<> != 任意值
2015-08-10