where后面的行子查询使用

行子查询(结果集一行多列或多行多列)
案例：查询员工编号最小并且工资最高的员工信息

SELECT *
FROM employees
WHERE (employee_id,salary)=(
SELECT MIN(employee_id),MAX(salary)
FROM employees
);

1.查询员工编号最小

SELECT MIN(employee_id)
FROM employees;

2.查询最高工资

SELECT MAX(salary)
FROM employees;

3.查询员工信息

SELECT *
FROM employees
WHERE employee_id = (
						SELECT MIN(employee_id)
						FROM employees;
 					)
 AND salary = (
						SELECT MAX(salary)
						FROM employees;
					 );