1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SQL> with t as (
2 select '+' as OPERATEUR, 6 as MONTANT from dual union all
3 select '-' as OPERATEUR, 2 as MONTANT from dual union all
4 select '+' as OPERATEUR, 4 as MONTANT from dual
5 )
6 select Sum( DECODE(OPERATEUR, '+', MONTANT, -1 * MONTANT) )
7 from t;
SUM(DECODE(OPERATEUR,'+',MONTANT,-1*MONTANT))
---------------------------------------------
8
SQL> with t as (
2 select '+' as OPERATEUR, 6 as MONTANT from dual union all
3 select '-' as OPERATEUR, 2 as MONTANT from dual union all
4 select '+' as OPERATEUR, 4 as MONTANT from dual
5 )
6 select Sum( DECODE(OPERATEUR, '+', MONTANT, -MONTANT) )
7 from t;
SUM(DECODE(OPERATEUR,'+',MONTANT,-MONTANT))
-------------------------------------------
8
SQL> |
Partager