作者Likefeeling (想来场心灵的裸奔)
看板TransCSI
标题[问题] 资料库的问题...
时间Sat Apr 8 19:46:59 2006
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
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.66.23.41
1F：推 msc0953:左右是两个表吧??! 04/08 23:31
2F：推 child47:这是一个表没错，不过是不是还有一个没划出来呢？ 04/11 00:53