I have the following brands table with total sales per month as a result of a previous query: id | date | total -----+----------+------ 123 | Apr-2012 | 100 123 | Mar-2012 | 150 123 | Jan-2012 | 500 987 | Apr-2012 | 5 987 | Mar-2012 | 0.10 987 | Feb-2012 | 8 I am looking to achieve the following: id

I have the following brands table with total sales per month as a result of a previous query: id | date | total -----+----------+------ 123 | Apr-2012 | 100 123 | Mar-2012 | 150 123 | Jan-2012 | 500 987 | Apr-2012 | 5 987 | Mar-2012 | 0.10 987 | Feb-2012 | 8 I am looking to achieve the following: id