1.行子查询,查询结果一行多列或者多行多列
#查询员工编号最小且工资最高的员工信息
#正常写法
SELECT *
FROM employees AS e
WHERE e.`employee_id` = (
SELECT MIN(employee_id)
FROM employees
) AND e.`salary` = (
SELECT MAX(salary)
FROM employees
);
#行子查询写法
```sql
SELECT *
FROM employees AS e
WHERE (e.`employee_id`,e.`salary`) = (
SELECT MIN(employee_id),MAX(salary)
FROM employees
);
#多个条件同时满足,且使用=连接