这样的ＳＱＬ语句在Ｏｒａ中不好用，看看错在哪里了？？

[icerain0322]

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))

[icerain0322]

主要实现将每个地区，离给定日期最近的那条记录

[bobfang]

select *
from pool a
where a.pool_05='北京市'
and a.pool_04 = (select max(pool_04)
from pool b
where b.pool_05='北京市'
and b.pool_04<='2003-02-03')

[HeavenHe]

oracle里面好像没有top这个函数

[HeavenHe]

没有top函数

[wangxian]

没有top函数 可以用rownum

[beckhambobo]

select * from
(select * from pool where pool_05='北京市' and pool_04<='2003-02-03' order by pool_04 desc)
where rownum<=1