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.