• Post Reply Bookmark Topic Watch Topic
  • New Topic

Need Help with MySQL Query  RSS feed

 
Kishen Singh Punjabi
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have group by datewise counts in a table. But sometimes there are no counts on particular dates.
Would it be possible to have the date even when there are no counts and mark the count as zero(0) in SELECT query.

Please help.

Thanks
 
K. Tsang
Bartender
Posts: 3648
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have a look at the function COALESCE when selecting the dates.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!