java面试题经典29例【第八季-常瑞鹏】.pdf

jjaavvaa面面试试题题经经典典2299例例 【【第第八八季季__常常瑞瑞鹏鹏】】 以下各个题 目将用到上图的4个表，其关联关系如图所示。这个四个表中字段的具体情况参看如 下内容： EMPLOYEES (employee_id number (6) not null,first_namevarchar2(20),last_name varchar2(25) not null,email varchar2(25) notnull,phone_number varchar2(20),hire_date date not null,job_id varchar2(10) notnull,salary number (8,2),commission_pct number (2,2),manager_idnumber (6),department_id number (4))   DEPT (department_id number (4) not null,department_name varchar2(30) notnull,manager_id number (6),location_id number (4))   locations(location_id number (4) not null,city varchar2(20))   job_grades(grade_level varchar2(3),lowest_sal number,highest_salnumber) 1.  EMPLOYEES (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salar y,commission_pct,manager_id,department_id)。job_grades(grade_level,lowest_sal,highes t_sal)。显示JOB_GRADES表的结构。创建一个查询显示所有雇员的name、job、department name、salary 和 grade。 DESC JOB_GRADES SELECT e.last_name, e.job_id, d.department_name, e.salary,j.grade_level FROM employees e, departments d, job_grades j WHEREe.department_id = d.department_id AND e.salary BETWEEN j.lowest_sal ANDj.highest_sal; -- OR SELECT e.last_name, e.job_id, d.department_name, e.salary,j.grade_level FROM employees e JOIN departments d ON (e.department_id =d.department_id) JOIN job_grades j ON (e.salary BETWEEN j.lowest_sal ANDj.highest_sal); 2.  EMPLOYEES (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salar y,commission_pct,manager_id,department_id)。创建一个查询显示那些在雇员 Davies 之后入 本公司工作的雇员的name 和 hire date。   SELECT e.last_name,e.hire_date   FROM employees e,employees davies   WHEREdavies.last_name = Davies   AND davies.hire_date e.hire_date 1 -- OR   SELECT e.last_name,e.hire_date   FROM employees e JOINemployees davies   ON (davies.last_name= Davies)   WHEREdavies.hire_date e.hire_date; 3.  EMPLOY