sql子查询、分页查询

where后边

USE myemployees;

"
WHERE、HAVING后边
"
#案例1：查询谁的工资比Abel高
①查询Abel的工资
SELECT salary 
FROM employees
WHERE last_name = 'Abel';

②查询salary>①的员工名字
SELECT last_name
FROM employees
WHERE salary>(
		SELECT salary 
		FROM employees
		WHERE last_name = 'Abel'
);

#案例二：返回job_id与141号员工相同，salary比143号员工多的员工姓名、job_id和工资
①查询141号员工的job_id
SELECT job_id
FROM employees
WHERE employee_id = 141;
②查询143号员工的工资
SELECT salary
FROM employees
WHERE employee_id = 143;
③查询job_id = ①，salary>②的员工姓名、job_id和工资
SELECT last_name,job_id,salary
FROM employees
WHERE job_id = (
		SELECT job_id
		FROM employees
		WHERE employee_id = 141
)
AND salary > (
		SELECT salary
		FROM employees
		WHERE employee_id = 143
);


#案例三：返回公司工资最少的员工的last_name、job_id、salary
①查询工资最少的员工
SELECT MIN(salary)
FROM employees
②查询工资=①的last_name、job_id、salary
SELECT last_name,job_id,salary
FROM employees
WHERE salary = (
		SELECT MIN(salary)
		FROM employees
);

#案例四：查询最低工资大于50号部门的最低工资的部门id和其最低工资
①50号部门的最低工资
SELECT MIN(salary)
FROM employees
WHERE department_id = 50;
②查询每个部门的部门id和最小工资，
且最小工资>①
SELECT MIN(salary),department_id
FROM employees
GROUP BY department_id
HAVING MIN(salary)>(
		SELECT MIN(salary)
		FROM employees
		WHERE department_id = 50
);

"
多行查询
"
#案例五：返回locati