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

《java面试题经典29例【第八季_常瑞鹏】.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、序java面试题经典29例【第八季_常瑞鹏】以下各个题目将用到上图的4个表，其关联关系如图所示。这个四个表中字段的具体情况参看如下内容：EMPLOYEES(employee_idnumber(6)notnull,first_namevarchar2(20),last_namevarchar2(25)notnull,emailvarchar2(25)notnull,phone_numbervarchar2(20),hire_datedatenotnull,job_idvarchar2(10)notnull,salarynumber(8,2),commission_pctnumb

2、er(2,2),manager_idnumber(6),department_idnumber(4))DEPT(department_idnumber(4)notnull,department_namevarchar2(30)notnull,manager_idnumber(6),location_idnumber(4))locations(location_idnumber(4)notnull,cityvarchar2(20))job_grades(grade_levelvarchar2(3),lowest_salnumber,highest_salnumber)1.EMP

3、LOYEES(employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id)。job_grades(grade_level,lowest_sal,highest_sal)。显示JOB_GRADES表的结构。创建一个查询显示所有雇员的name、job、departmentname、salary和grade。DESCJOB_GRADESSELECTe.last_name,e.job_id,d.department

4、_name,e.salary,j.grade_levelFROMemployeese,departmentsd,job_gradesjWHEREe.department_id=d.department_idANDe.salaryBETWEENj.lowest_salANDj.highest_sal;--ORSELECTe.last_name,e.job_id,d.department_name,e.salary,j.grade_levelFROMemployeeseJOINdepartmentsdON(e.department_id=d.department_id)JOINj

5、ob_gradesjON(e.salaryBETWEENj.lowest_salANDj.highest_sal);2.EMPLOYEES(employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id)。创建一个查询显示那些在雇员Davies之后入本公司工作的雇员的name和hiredate。SELECTe.last_name,e.hire_dateFROMemployeese,employeesdavies

6、WHEREdavies.last_name='Davies'ANDdavies.hire_date

7、ct,manager_id,department_id)。显示所有雇员的names和hiredates，他们在他们的经理之前进入本公司，连同他们的经理的名字和受雇日期一起显示。列标签分别为Employee、EmpHired、Manager和MgrHired。SELECTw.last_name,w.hire_date,m.last_name,m.hire_dateFROMemployeesw,employeesmWHEREw.manager_id=m.employee_idANDw.hire_date