sy2_2_3.sql

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

select person.*,year,month,base,bonus,deduct,fact
        from person,pay
        where person.no=pay.no and year=2005 and month=1 and 
              fact>(select avg(fact) from pay
                    where year=2005 and month=1)