I am trying to get the daily/date wise count of
installed meters. The query is below.
SELECT COUNT(ins.`id`) AS Total, DATE(ins.`sync_date`) AS 'Date Time' FROM `installations` ins GROUP BY ins.`sync_date` ORDER BY ins.`sync_date` DESC
It's giving me a single value against the date all I want is the total count per day.
Any help would be highly appreciated.
Have an answer?