Displaying Missing Rows in a Group By Select Statement
437599Dec 18 2007 — edited Dec 20 2007I have a query that looks like the following
select coll_time,sum(coll_size) from coll_table
where coll_time between '2007-11-15' and '2007-11-20'
group by coll_time;
This returns
coll_time sum(coll_size)
2007-11-15 123456
2007-11-16 234567
2007-11-17 345678
2007-11-19 456789
As you can see, there is no data for the 18th.
Can someone please explain how I can have the query output a row for the 18th. The sum can be 0 or null.
Thanks.