create table test (id number,name varchar2(1));insert into test values(1,'a');insert into test values(2,'b');select (
(select id from test where name = 'b')-
(select id from test where name = 'a')) from dual;所以
select
(select sum(a) from bbb where date='20050101')
-
(select sum(a) from bbb where date='20041231')
from dual;
(select id from test where name = 'b')-
(select id from test where name = 'a')) from dual;所以
select
(select sum(a) from bbb where date='20050101')
-
(select sum(a) from bbb where date='20041231')
from dual;
from bbb x,bbb y
where x.date=to_date('20050101','YYYYMMDD') and y.date=to_date('20041231','YYYYMMDD')呵呵,没考虑效率。
FROM bbb
WHERE date IN ('20050101','20041231');