最新话题
-
全部 SELECT employee_id,department_name from employees e FULL JOIN departments d on e.department_idd.d...0287 -
0183 -
1.显示所有员工的姓名，部门号和部门名称。 2.查询90号部门员工的job_id和90号部门的location_id 3.选择city在Toronto工作的员工的 last_name , job_i...0594 -
-
SELECT e.employee_id,d.department_name FROM employees e,departments d WHERE e.department_idd.departm...0192
-
SELECT e.employee_id,d.department_name FROM employees e,departments d WHERE e.department_id d.depar...0191
-
SELECT e.employee_id,d.department_name FROM employees e,departments d WHERE e.department_idd.departm...0206
-
SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_idd.department_...0209
-
sql92 内连接 SELECT e.employee_id,d.department_name FROM employees e,departments d WHERE e.department_i...0201
-
SELECT e.employee_id,d.department_name from employees e,departments d WHERE e.department_idd.departm...0205
-
SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_idd.department_...0205
-
SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_idd.department_...0218
-
select employee_id,department_name from employees,departments where employees.department_id departm...0179
-
desc employees; desc departments; SELECT employee_id,department_id,location_id from employees,depart...0219
-
查询表结构 DESC employees; DESC departments; 注意写表别名和连接条件 ‘e’和‘d’,where SELECT e.employee_id,d.departmen...0217
-
SELECT employee_id,department_name FROM employees,departments WHERE employees.employee_id departmen...0197
-
desc employees; desc departments; select e.employee_id,d.department_name from employees,departments;...0215
-
SELECT e.last_name,d.department_id FROM employees e,departments d WHERE d.department_ide.department_...0215
-
SELECT employee_id,department_name from employees,departments WHERE employees.employee_id departmen...0227
-
SELECT employee_id,department_name from employees,departments where employees.department_id departme...0193