sy2_2_1.sql

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

select*
        from person
        where no in(select no from pay
                    where year=2005 and month=1 and 
                          fact>(select fact from pay
                                where year=2005 and month=1 and no='000001'
                               )
                   )