need to return two sets of data with two different where clauses

by 
SELECT budget_id, 
       SUM(IF(type="allocation", points, 0)) AS allocated,
       SUM(IF(type="issue", points, 0)) AS issued
FROM transactions
GROUP BY budget_id

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. WHERE vs HAVING
  5. Join tables with SUM issue in MYSQL
  6. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  7. Return default result for IN value regardless
  8. How can I search (case-insensitive) in a column using LIKE wildcard?
  9. Search for “whole word match” in MySQL
  10. sql joins as venn diagram
  11. How can I join multiple SQL tables using the IDs?
  12. Check if MySQL table exists without using “select from” syntax?
  13. MySQL, better to insert NULL or empty string?
  14. SQL: selecting rows where column value changed from previous row
  15. Why do results from a SQL query not come back in the order I expect?
  16. How to generate data in MySQL?
  17. MySQL combine two columns and add into a new column
  18. SQL query of multiple values in one cell
  19. How to skip certain database tables with mysqldump?
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. How to set a MySQL row to READ-ONLY?
  22. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  23. Mysql: Order by like?
  24. Getting first day of the week in MySql using Week No
  25. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  26. How to get a list of months between two dates in mysql
  27. How to format number with “.” as thousands separator and “,” as decimal separator?
  28. Using DISTINCT and COUNT together in a MySQL Query
  29. How to check if field is null or empty in MySQL?
  30. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

Leave a Comment