Ask a question    Sign Up Sign In
  1. Home
  2. mysql - need to return two sets of data with two different where clauses

735 votes
1 answers

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

Get the solution ↓↓↓

Solution:

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



543
votes

Answer

Solution:

    select budget_ID, 
     sum(case when type = 'allocated' then points else 0 end) as allocated,
     sum(case when type = 'issued' then points else 0 end) as issued
     ..rest of your query...
    group by budget_ID

Cases can be used to sum only when a certain criteria is met.

Write your answer



Share solution ↓

Additional Information:
Link To Source
People are also looking for solutions of the problem: your system folder path does not appear to be set correctly. please open the following file and correct this: index.php

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Similar questions

Find the answer in similar questions on our website.

416 php - Save data to two different tables in CakePHP 3
475 php - Why would you use two (or more) databases instead of one?
68 php - Laravel routing & database MySQL different output
584 Connecting/combining multiple user tables in a MySQL database for different PHP applications on a server subdomains/subfolders
449 mysql - Insert Paypal payment date in database with PHP
52 php - Cannot insert rows into mysql database from an html form using phpmyadmin
131 php - Return rows from multidimensional array based on value of an element
494 how to make two folders with the same name in the same path in PHP
861 How to filter day and date from database using PHP and MySQL
407 Organize Questions & Answers from database in php and mysql

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.





About the technologies asked in this question

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.