CODEWITHSUNDEEP
mysql
user3235016
user3235016

Reputation: 317

Compute income via date

I have a table which contains name(varchar),date(datetime), and income(money) for the specific date

EXAMPLE:

robert 10/10/13 1200.0000
jacob 10/10/19  2300.0000

How do I compute my total income from a specific date(Like from 10/10/13 to 10/10/28)

Upvotes: 0

Views: 35

Answers (1)

user1320635
user1320635

Reputation:

For all:

SELECT name_column, sum(IFNULL(amount_column, 0))
FROM income_table
WHERE date_column BETWEEN '[INSERT FROM DATE]' AND '[INSERT UNTIL DATE]'
GROUP BY name_columns

For one:

SELECT sum(IFNULL(amount_column, 0))
FROM income_table
WHERE date_column BETWEEN '[INSERT FROM DATE]' AND '[INSERT UNTIL DATE]'
AND name_column = '[INSERT NAME]'

Upvotes: 2

Related Questions