SUM(if((date_format(DATE_ADD(TradeTime,interval 0 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未進T金額,
SUM(if((date_format(DATE_ADD(TradeTime,interval 1 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未進T加1金額,
SUM(if((date_format(DATE_ADD(TradeTime,interval 2 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未進T加2金額,
SUM(if((date_format(DATE_ADD(TradeTime,interval 3 MONTH),'%Y-%m')!=left(b.BillPeriod,7) or BusinessBillNo='') AND TravelType=1,OrderMoney,0)) AS 未進大于T加2金額,
當條件滿足其中一個的時候，只展示滿足條件那一列的資料，這個需要怎么解決呀
uj5u.com熱心網友回復：
case whenuj5u.com熱心網友回復：
case when xxx then yyy when 111 then 222 end轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/38063.html
標籤：基礎類
上一篇：Java作業