mysql showing null values for group by statements

Posted by khelll on Stack Overflow See other posts from Stack Overflow or by khelll
Published on 2010-06-11T12:23:59Z Indexed on 2010/06/11 12:33 UTC
Read the original article Hit count: 217

Filed under:
|
|
|

I'm doing select sum(clicks), date from stats group by date;, however when the sum is null for some date, the whole row is discarded, I want to see: | null | some_date |, how to do so?

Cheers,

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql