是不是这样的?select t4.*, t3.sum1
from t t4,
(select t1.name, t1.date, nvl(sum(t2.sk), 0) sum1
from t t1, t t2
where t1.name = t2.name(+)
and t1.date < t2.date(+)
group by t1.name, t1.date) t3
where t3.name = t4.name
and t3.date = t4.date
and t3.sum1 < t4.all
from t t4,
(select t1.name, t1.date, nvl(sum(t2.sk), 0) sum1
from t t1, t t2
where t1.name = t2.name(+)
and t1.date < t2.date(+)
group by t1.name, t1.date) t3
where t3.name = t4.name
and t3.date = t4.date
and t3.sum1 < t4.all
谢谢啦!