• davidandrewhelmer
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Guys,

 

i found following solution but this one shows the result based on days in month.

 

select day_only(createdDate) createdonDate,
count(createdDate) numCreated
from account
group by day_only(createdDate)
order by day_only(createdDate) desc

 

But i want result based on month.

 

 

 

Regards,

Vishal Thoriya.