ANY关键字表示任何一个,这在内层查询中,只要满足任一条就执行外层查询
字段>ANY 大于里面的任意一条
select fid from manydate WHERE fid = ANY(SELECT fid from manydate)
ALL表示要满足所有的条件
select fid from manydate WHERE fid > ALL(SELECT fid from manydate)
ANY ALL前面接比较符号,后面接一个子查询