#1、查询工资大于 12000 的员工姓名和工资
SELECT
last_name,
salary
FROM
employees
WHERE
salary>12000;
#2、查询员工号为 176 的员工的姓名和部门号和年薪
SELECT
last_name,
department_id,
salary*12*(1+IFNULL(commission_pct,0)) AS 结果
FROM
employees
WHERE
employee_id = 176;
#3、选择工资不在 5000 到 12000 的员工的姓名和工资
SELECT
last_name,
salary
FROM
employees
WHERE
NOT(salary BETWEEN 5000 AND 12000);
#4、选择在 20 或 50 号部门工作的员工姓名和部门号
SELECT
last_name,
department_id
FROM
employees
WHERE
department_id=20 OR department_id=50;
#5、选择公司中没有管理者的员工姓名及 job_id
SELECT
last_name,
job_id
FROM
employees
WHERE
manager_id IS NULL;
#6、选择公司中有奖金的员工姓名,工资和奖金级别
SELECT
last_name,
salary
FROM
employees
WHERE
commission_pct IS NOT NULL;
#7. 选择员工姓名的第三个字母是 a 的员工姓名
SELECT
last_name
FROM
employees
WHERE
last_name
LIKE
'__a%';
#8. 选择姓名中有字母 a 和 e 的员工姓名
SELECT
last_name
FROM
employees
WHERE
last_name
LIKE
'%a%' OR '%e%';
#9. 显示出表 employees 表中 first_name 以 'e'结尾的员工信息
SELECT
*
FROM
employees
WHERE
first_name
LIKE
'%e';
#10. 显示出表 employees 部门编号在 80-100 之间 的姓名、职位
SELECT
last_name,
job_title,
department_id
FROM
employees,
jobs
WHERE
department_id BETWEEN 80 AND 120;
#11. 显示出表 employees 的 manager_id 是 100,101,110 的员工姓名、职位
SELECT
manager_id,
last_name,
job_title
FROM
employees,
jobs
WHERE
manager_id IN('100','101','110');
#问以下sql语句执行结果是否一致
SELECT
*
FROM
employees
WHERE
commission_pct LIKE '%%' AND last_name LIKE '%%';
-- ----------------------------------------------------
SELECT
*
FROM
employees
#分析:对于通配符%%,表示的是有值的字段,不可显示为null的字段