MySQL PayPal Count

SELECT
a.date,
COUNT(*) as daily_count,
(SELECT COUNT(*) FROM paypal_2014 b WHERE b.Item_ID != '' AND b.date <= a.date) as running_total FROM paypal_2014 a WHERE a.Item_ID != '' GROUP BY a.date ORDER BY a.date;

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares