Do you know how I can get the total of a GROUP BY
? Let me explain: a grouping is made per plan and each plan carries its total; I need to get the total of all that.
An example is
(plan) (cantidad usuarios no admin) costo plan total
admin 5 4 (5*4 = 20)
silver 7 5 (7*5 = 35)
gold 20 10 (10*20 = 200)
----------------------------------------------------------------------
gran total = 255
Try ROLLUP BUT it does not work. it gives me an erroneous result
The grand total is what I want to obtain and now if you see that you already know that it is because each one has a different cost. What I need is the query that gets great total.