21-Jan-2022
.
Admin
Hello Friends,
This article will give you example of MySQL sum query with if condition. I explained simply about MySQL sum with if multiple conditions. This tutorial will give you simple example of MySQL sum with if condition statement.
In this post, You'll learn use sum with condition in MySQL. i will show you use of sum with if condition in SQL query.
Here i will give you many example for MySQL sum with if condition.
Table: users_payment
So, let's see bellow solution:
Solution SQL Query:
SELECT
SUM(CASE
WHEN type = "CASH"
THEN amount
ELSE 0
END) AS total_cash,
SUM(CASE
WHEN type = "CREDIT_CARD"
THEN amount
ELSE 0
END) AS total_credit_card
FROM `users_payment`
Output:
It will help you...
#MySQL