sy2_1_6.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 4 行

select deptno as 部门,sum(fact) as 总额
       from pay,person
       where pay.no=person.no and year=2005
       group by deptno