sql - 明智地找到每个员工部门的薪水

Question

我有以下 3 个表 Emp(eid: integer, ename: string, age: integer, sale: numeric) Works(eid: integer, did: integer, pct_time: integer) Dept(did: integer, dname: string, budget: numeric , managerid: 整数)

我想编写 oracle sql 查询来查找每个员工部门的薪水

标签： sqloracle

Answer 1

就像是：

select d.dname, e.ename, w.pct_time * e.salary
from emp as e
inner join works as w using (eid)
inner join dept as d using (did)
     order by w.did