where 后面的行子查询，，，行子查询（结果集一行多列或者多行多列）

行子查询（结果集一行多列或者多行多列）
案例：查询员工的编号最小并且工资最高的员工的工资的员工的信息
1.查询最小的员工的编号

select min (employee_id)
from employees

2.查询最高的工资

select max(salary)
from employees

3.查询员工的信息

select *
from employees
where employees_id=(
select min (employee_id)
from employees
)and salary =(
select max(salary)
from employees
);

方法二：

select *
from employees
where (employees_id,salary)=(
select min(employee_id),max(salary)
from employees)