SQL数据库知识现场解答

发布网友

我来回答

1个回答

热心网友

请参考:
(1)
select e.姓名,e.住址
from department d,employee e
where d.department_no=e.department_no and d.部门名称='IPMS';
(2)
select p.产品名, e.姓名 as 产品负责人姓名,d.部门名称,
e2.姓名 as 部门负责人姓名,e2.电话 as 部门负责人电话
from 产品表 p,employee e,department d,employee e2
where p.project_manager=e.Employee_no and e.department_no=d.department_no

and d.department_manager=e2.Employee_no
and p.产品名='《计量支付》'
(3)
select e.姓名,decode(e.性别,'男',e.地址,'女',e.电话号码,0) 通讯方式
from employee e
(4)
select e.employee_no,e.姓名,p.project_no

from employee e left outer join 产品表 p
on e.employee_no=p.project_manager

(5)
select e.姓名,d.部门名称,e2.姓名,e2.电话,(select p.产品名 from 产品表 p where e.employee_no=p.project_manager) as 产品名
from employee e,department d,employee e2
where e.department_no=d.department_no and d.Department manager=e2.employee_no

声明声明:本网页内容为用户发布,旨在传播知识,不代表本网认同其观点,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。E-MAIL:11247931@qq.com