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
