大家好，我想統計 列值 相同對應的金額統計，怎么用SQL，謝謝
uj5u.com熱心網友回復：
也就是型別是18的累加起來，型別是15的累加起來，再用18的累加值-15的累加值uj5u.com熱心網友回復：
SELECT SUM(DECODE(OPERATION,18,VIRTUALMONEY,0))-SUM(DECODE(OPERATION,15,VIRTUALMONEY,0))FROM TABLE_NAME GROUP BY CARDNO ;
uj5u.com熱心網友回復：
with t as(
select '6215990' cardno,'巫巧珍' username, '15' operation, 1 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '15' operation, 2 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '15' operation, 3 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '18' operation, 4 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '18' operation, 5 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '18' operation, 6 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '18' operation, 7 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '18' operation, 8 virtualmoney from dual
union all
select '6215990' cardno,'巫巧珍' username, '19' operation, 9 virtualmoney from dual
)
select sum(decode(operation,'18',virtualmoney,-virtualmoney)) from t where operation in('15','18');
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/202746.html
標籤：基礎和管理
上一篇：Oracle 當日從0點開始到24每半個小時的資料量統計
下一篇：哪個大哥能幫忙寫一個SQL