sql - SQL ORACLE，差异

Question

这是代码

 select sum(post_sales) from post_sales;

给 50,000

select sum(sales) from sales;

给 100,000

我想减去 100,000 - 50,000

Oracle SQL 中的语法是什么？

标签： sqloracledifferencearithmetic-expressions

Answer 1

你可以把这些放在一个select：

select ( (select sum(sales) from sales) -
         (select sum(post_sales) from post_sales)
       ) as diff
from dual;