未经测试,但应该可以工作:
SELECT
(SELECT value from table where date between DATE1 and DATE2) -
(SELECT value from table where date between DATE3 and DATE4)
FROM dual;
假设您肯定SELECT value
会返回一个值
ORACLE SQL获取从2条select语句中检索到的两个值的差
未经测试,但应该可以工作:
SELECT
(SELECT value from table where date between DATE1 and DATE2) -
(SELECT value from table where date between DATE3 and DATE4)
FROM dual;
假设您肯定SELECT value
会返回一个值