行子查询(结果集一行多列或者多行多列)
案例:查询员工的编号最小并且工资最高的员工的工资的员工的信息
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)