Gary Greenberg schrieb:
I have a table that stores performed transactions and I need to build a
histogram of a number of transactions per day in the requested period.
So, I made a simple query with the group by clause which returns me what
I need:
2008-04-1665456204
2008-04-17190838546
On Thursday 24 April 2008 12:26:09 pm Gary Greenberg wrote:
> except that there is no entry for April 20th as there were no
> transactions at that day. I need a query to return me zero for that day.
> I.e. I need uninterrupted sequence of dates.
> I am beating my head at this problem for the whole
I have a table that stores performed transactions and I need to build a
histogram of a number of transactions per day in the requested period.
So, I made a simple query with the group by clause which returns me what
I need:
2008-04-16 65456204
2008-04-17 190838546
2008-04-18 89090
