[Quote=引用 3 楼 liulongjin2008 的回复:]
select *
from table_name b
where 日期>to_date('2009-03-02 00:00:00','yyyy-mm-dd hh24:mm:ss')
and not exists (select 'X' from table_name a from a.日期=b.日期 and f1 <=0 )
[/Quote]
速度不是一般的慢
select *
from table_name b
where 日期>to_date('2009-03-02 00:00:00','yyyy-mm-dd hh24:mm:ss')
and not exists (select 'X' from table_name a from a.日期=b.日期 and f1<=0 )