sy2_2_2.sql

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

select*
        from person
        where no in(select no from pay
                    where year=2005 and month=1 and 
                          fact>all(select fact from pay,person
                                   where person.no=pay.no and year=2005 and month=1 and deptno='000102'
                                  )
                   )