Posts by Rafael Mota • 41 points

• 2

  votes

  4

  answers

  1133

  views

  A: Return a sum in separate rows in mysql

  you can try this way select sum(case when operacao=2 then valor*-1 else valor end) from tabela GROUP by id_cliente

  php mysql

  answered 8 years, 2 months ago Rafael Mota 41

• 2

  votes

  4

  answers

  103

  views

  A: Problems formatting the date type returned from select

  try using the mysql date format function select date_format(D.Mes_Ref,'%m/%Y')

  php mysql date

  answered 8 years, 2 months ago Rafael Mota 41