[Solved] MySQL Name Profit with date range [closed]

by


Try this:

select name, sum(profit)
from yourtable
WHERE 
date >= '2014-04-19 00:00:00' 
AND 
date <  '2014-04-19 23:59:59'
group by name

solved MySQL Name Profit with date range [closed]