查询

/*
 *select语句
*/
# 1.查询工资大于12000的员工姓名和工资
SELECT last_name, salary
FROM  employees
WHERE salary >12000;

#2.查询员工号为176的员工的姓名和部门号和年薪
SELECT last_name,department_id,(salary+IFNULL(commission_pct,0))*12 年薪
FROM employees
WHERE employee_id=176;

#3.选择员工不在5000到12000的员工的姓名和工资
SELECT last_name,salary
FROM employees
WHERE salary <> (salary>=5000 AND salary <=12000);

#4.选择在20或50部门工作的员工的姓名和部门号
SELECT last_name,department_id
FROM employees
WHERE department_id IN(20,50);

#5.选择公司中没有管理者的员工姓名及job_id
SELECT last_name,job_id
FROM employees
WHERE manager_id IS NULL;

#6.选择公司中有奖金的员工姓名，工资和奖金级别
SELECT last_name,salary,commission_pct
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 last_name LIKE "%e%";

#9.显示出表employees表中first_name以e结尾的员工信息。
SELECT *
FROM employees
WHERE first_name LIKE "%e";

#10.显示出表employees部门编号在80-100之间的姓名、职位
SELECT last_name,job_id,department_id
FROM employees
WHERE department_id BETWEEN 80 AND 100;

#11.显示出表employees的manager_id 是100、101、110 的员工姓名、职位
SELECT last_name,job_id,manager_id
FROM employees
WHERE manager_id IN(100,101,110);

•