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

序 java面试题经典29例【第八季_常瑞鹏】 以下各个题目将用到上图的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.? EMPLOYEES(employee_id,first_name,last_name,email,phone_number