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
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