mysql 两个查询结果运算减

Question

select sum(money) as s1 from w_user_money where uid=10086 and money_plusminus=1；select sum(money) as s2 from w_user_money where uid=10086 and money_plusminus=2；求 s1-s2 mysql 怎么写

Answer 1

1 2 3 4 5

select (  (select sum(money) as s1 from w_user_money where uid=10086 and money_plusminus=1) - (select sum(money) as s2 from w_user_money where uid=10086 and money_plusminus=2) )

 

Answer 2

将上面查询的结果当成表再写一个语句
select s1-s2 from (select sum(money) as s1 from w_user_money where uid=10086 and money_plusminus=1),(select sum(money) as s2 from w_user_money where uid=10086 and money_plusminus=2);