select * from pool a where (a.pool_05='北京市' and a.pool_04 = (select top 1 pool_04 from pool b where b.pool_05='北京市' and b.pool_04<='2003-02-03' order by pool_04 desc))
...全文
466打赏收藏
这样的SQL语句在Ora中不好用,看看错在哪里了??
select * from pool a where (a.pool_05='北京市' and a.pool_04 = (select top 1 pool_04 from pool b where b.pool_05='北京市' and b.pool_04<='2003-02-03' order by pool_04 desc))