i am trying to retrive sum of amount deliverd group by date...can utell how to display total amount of each date in sql
Use group BY:select date, sum(amount)from ...group by date