首頁(yè) 猿問(wèn) mysql 兩個(gè)查詢結(jié)果運(yùn)算減

mysql 兩個(gè)查詢結(jié)果運(yùn)算減

MySQL

qq_笑_17 2019-03-27 17:17:52

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 怎么寫(xiě)

查看完整描述

2 回答

米脂

TA貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超3個(gè)贊

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)

)

反對(duì) 回復(fù) 2019-03-30

偶然的你

TA貢獻(xiàn)1841條經(jīng)驗(yàn) 獲得超3個(gè)贊

將上面查詢的結(jié)果當(dāng)成表再寫(xiě)一個(gè)語(yǔ)句
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);

反對(duì) 回復(fù) 2019-03-30