Posts by Pastor • 36 points

• 2

  votes

  4

  answers

  1133

  views

  A: Return a sum in separate rows in mysql

  Replace column and table names: select sum(case when operacao='01' then valor else 0 end) deposito, sum(case when operacao='02' then valor else 0 end) retirada, sum(case when operacao='01' then…

  php mysql

  answered 8 years, 6 months ago Pastor 36