话题_我爱换客网

最新话题

顾的笔记

思考：三张表不能合成一张表查询员工ID和部门名称错误示范,把每个员工和每个部门都排序一遍 SELECT employee_id,department_name FROM employees, ...

chemss 711 天前发表于 [学园巷]

0

465
张士晨——表通天塔

select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,.locations ...

暮夏 711 天前发表于 [学园巷]

4

519
。。。

SELECT emp.employee_id,emp.last_name,mgr.employee_id,mgr.last_name FROM employees emp,employees mgr ...

匿名用户 711 天前发表于 [学园巷]

0

502
甄帅垚

select employee_id,last_name,department_name,city from employees,departments,locations where employe...

甄帅垚 711 天前发表于 [学园巷]

3

497
陈煜杭--脑瓜子嗡嗡的吧

select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...

蓝桉C 711 天前发表于 [学园巷]

1

476
闫冬浩

查询员工的employee_id,last_name,department_name,city select employee_id,last_name,department_name,city fr...

还好哈哈哈 711 天前发表于 [学园巷]

1

477
自连接123

select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...

abcd` 711 天前发表于 [学园巷]

0

469
谷加伟——多表查询

SELECT e.employee_id,e.last_name, d.department_id,i.city FROM employees e,departments d,locations i;...

尘缘 711 天前发表于 [学园巷]

0

485
lululu

select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...

lululu 711 天前发表于 [学园巷]

0

468
自连接

SELECT e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...

xiao 711 天前发表于 [学园巷]

0

502
NIHAO

lcll 711 天前发表于 [学园巷]

0

375
张博研——自连接

CGPT 711 天前发表于 [学园巷]

1

394
zy

SELECT employee_id,last_name,department_name,city from employees,departments,locations WHERE employe...

北陌 711 天前发表于 [学园巷]

0

459
多表查询。

SELECT employee_id,last_name,department_name,city from employees,departments,locations WHERE employe...

莉莉芙的 711 天前发表于 [学园巷]

0

459
瓜瓜瓜瓜

SELECT employee_id,last_name,department_name,city from employees e,departments d,locations l WHERE e...

瓜瓜 711 天前发表于 [学园巷]

0

464
多表查询4.12

SELECT employee_id, last_name,department_name,city FROM employees,departments,locations WHERE employ...

流泪鲫鱼饼 711 天前发表于 [学园巷]

0

466
多表查询05049

课前回顾SELECT e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locatio...

蒂催溪程 711 天前发表于 [学园巷]

0

464
郭佳豪——软件技术五班

SELECT employee_id,last_name,department_name,city FROM employees e,departments d,locations l WHERE e...

黎见梦中人 711 天前发表于 [学园巷]

0

510
高一鸣---自连接

select employee_id,last_name ,department_name,city from employees,departments,locations where employ...

A鸣 711 天前发表于 [学园巷]

0

454
石浩洋——自连接

石浩洋 711 天前发表于 [学园巷]

0

378

推荐话题

热门话题