Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need Help with MySQL Query

 
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: 3583
16
Android Java
  • 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