Advertisement
Guest User

Untitled

a guest
Aug 31st, 2015
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT
  2. MONTHNAME(DATA) AS m,
  3. sum(valor) AS p
  4.  
  5. FROM
  6. despesas
  7.  
  8. GROUP BY
  9. MONTHNAME(DATA)
  10.  
  11. ----------------------------------------
  12. - MONTH - SUM DESPESAS - SUM RECEITAS -
  13. - JANUARY - 10432.2 - 103.3 -
  14. - MARCH - 102.2 - 0 -
  15. - APRIL - 101.2 - 4 -
  16. ----------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement