pl/sql 过滤，排序，帅选数据小练习02

--1.查询工资大于12000的员工的姓名和工资

select last_name,salary
from employees
where salary > 12000

--2,查询员工工号为176的员工的姓名和部门

select last_name,department_id
from employees
where employee_id = 176

--3,选择工资不在5000到12000的员工姓名和工资

select last_name,salary
from employees
--where salary<5000 or salary >12000
where salary  not between 5000 and 12000

--4,选择雇佣时间在1998-02-01到1998-05-01之间的员工的姓名，job_id和雇佣时间

select last_name,job_id,hire_date
from employeees
--where hire_date between '1-2月-1998' and '1-5月-1998'
where to_char(hire_date,'yyyy,mm,dd') between '1998-02-01' and '1998-05-01'

--5,选择在20号或在50号部门工作的员工姓名和部门的门号

select last_name,department_id
from employees
where department_id = 20 or department_id = 50
--where department_id (20,50)

--6,选择在1994年雇佣的员工的姓名和雇佣时间

select last_name,hire_date
from employees
--where hire_date like '%94'
where to_char(hire_date,'yyyy')='1994'

--7,选择公司中没有管理者的员工姓名及job_id

select last_name,job_id
from employees
where maneger_id is null

--8,选择公司中有奖金的员工姓名，工资和奖金级别

select last_name,salary,commission_pct
from employees
where commiddion_pct is not null

--9，选择姓名中有字母a,和e的员工姓名

select last_name
from employees
where last_name like '%a%e%' or lasr_name like '%e%a%'

--10，选择姓名的第三个字母是a的员工姓名

select last_name
from employees
where last_name like '__a%'