SQL中的all any some

select last_name,job_id,salary
from employees
where salary > all(select salary from employees
                       where job_id='SA_MAN')

all --查询 salary 大于job_id='SA_MAN'的最大的salary的员工信息

------------------------------------------------------------------------------------------------------------------------------------------------

select last_name,job_id,salary                                ==       select last_name,job_id,salary
from employees                                                       ==       from employees
where salary > any(select salary from employees   ==       where salary > some(select salary from employees
                       where job_id='SA_MAN')                  ==       where job_id='SA_MAN')

any和 some是一样的

--查询salary大于大于job_id='SA_MAN'的最小的salary 的员工信息