oracle 基本练习.docVIP

查询工资大于12000的员工姓名和工资 select last_name, salary from employees where salary 12000 查询员工号为176的员工的姓名和部门号 select last_name, department_id from employees where employee_id = 176 选择工资不在5000到12000的员工的姓名和工资 select last_name, salary from employees where salary not between 5000 and 12000 选择雇用时间在1998-02-01到1998-05-01之间的员工姓名，job_id和雇用时间 select last_name, job_id, hire_date from employees where hire_date between 1-2月 -1998 and 1-5月 -1998 选择在20或50号部门工作的员工姓名和部门号 select last_name, department_id from employees where department_id in (20, 50) 选择在1994年雇用的员工的姓名和雇用时间 select last_name, hire_date from employees where h