-- where后面的 行子查询使用(一行多列,多行多列)
-- 案例:查询员工编号最小并且工资最高的员工信息 (具备条件的不一定存在)
-- 使用列子查询
SELECT *
FROM employees
WHERE employee_id=(
SELECT MIN(employee_id)
FROM employees)
AND salary=(
SELECT MAX(salary)
FROM employees);
-- 行子查询
SELECT *
FROM employees
WHERE (employee_id,salary)=(
SELECT MIN(employee_id),MAX(salary)
FROM employees);