MySQL Forums
Forum List  »  Newbie

Urgent help required to optimize query for cumulative count
Posted by: Prad drone
Date: March 05, 2016 06:36AM

Hi All,
I have database table,Which have following field.

<Ids> <Data>
2 2015-01-20
10 2015-07-10
12 2015-7-20
35 2015-12-27
114 2016-01-05
215 2016-01-10
361 2016-02-12

Need to write a query which can produce output in terms of month, cumulative month for last 6 months, if month not exits then add the previous count but data need to be displayed in terms of months

Year Month Count 2015 10 0 3
2015 11 0 3
2015 12 1 4
2016 1 2 6
2016 2 1 7
2016 3 0 7

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Urgent help required to optimize query for cumulative count
March 05, 2016 06:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.