dear ali,
something like
select machine,date_part('day' , date) , sum(withdrawals) from
Table where date_part('month' , date)='month in question' group by
machine,date_part('day' , date) ;
will give you agrregated withdrawals by machine and day,
use the frontend language for formatting it.
no
Dear All,
I am new to Relational Databases and SQL and my
background in ODBs is clouding my way to solving what seems to be a simple
problem. I am sure many of you have met it many times.
OK, I have a table as follows:
ID Machine
Date
Withdrawals
1
1
01/
