作者msc0953 (我是杀菌)
看板TransCSI
标题Re: [问题] 资料库的问题...
时间Sat Apr 8 23:33:29 2006
※ 引述《Likefeeling (想来场心灵的裸奔)》之铭言：
: Examine the data of the EMPLOYEES table.
: EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers
: and refers to the EMPLOYEE_ID)
: EMPLOYEE_ID EMP_NANE DEPT_ID MGR_ID JOB_ID SALARY
: 101 Smith 20 120 SA_REP 4000
: 102 Martin 10 105 CLERK 2500
: 103 Chris 20 120 IT_ADMIN 4200
: 104 John 30 108 HR_CLERK 2500
: 105 Diana 30 108 HR_MGR 5000
: 106 Bryan 40 110 AD_ASST 3000
: 108 Jennifer 30 110 HR_DIR 6500
: 110 Bob 40 EX_DIR 8000
: 120 Ravi 20 110 SA_DIR 6500
: Evaluate this SQL statement AND WRITE DOWN its output?:
: SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary,
: m.employee_id "Mgr_id", m.emp_name "Manager"
: FROM employees e, employees m
: WHERE e.mgr_id = m.employee_id
: AND e.salary > 4000;
: 题目就是这样...请问这一题要算什麽?
: 要怎麽解...题目都看不懂...请各位大大帮帮忙:P
不知道你有没有正确答案?
输出结果：
Emp_id Employee e.salary Mgr_id Manager
120 Ravi 4200 120 IT_ADMIN
108 Jennifer 5000 108 HR_MGR
110 Bob 6500 110 HR_DIR
110 Bob 6500 110 SA_DIR
其实我不是很确定...= =?有错请大家尽量纠正= =+
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.135.196.47