Skip to main content

Mysql : Rollup command ..last row of the result will show the total of sum and count function

Rollup command ..last row of the result will show the total of sum and count function


SELECT month,sum(star),sum(rating),count(*) FROM `rolluptest` group by month with rollup


+-------+-----------+-------------+----------+
| month | sum(star) | sum(rating) | count(*) |
+-------+-----------+-------------+----------+
| Feb   |        19 |           4 |        3 |
| Jan   |         9 |           4 |        2 |
| Mar   |         1 |           3 |        1 |
| NULL  |        29 |          11 |        6 |
+-------+-----------+-------------+----------+

Comments

Post a Comment

Popular posts from this blog

Recursive array calls one after another through promise

 data = [1,2,3,4] rules = [                     function(d){ return d.map(x => x * 2); },                     function(d){ return d.map(x => x * 2); }                ] recursive(0,rules,data); function somelongrunningprocess(rule, data){     var d = $.Deferred();     setTimeout(function(){ var result = rule.call(undefined,data); d.resolve(result); },1000);     return d; } function recursive(index, rules, data) {             if(index < rules.length) {                 $.when(somelongrunningprocess(rules[index],data)).then(function(response){                     console.log("after_rule",respon...
Post a Comment
Read more

Javascript Generator as promise

     function* makeIterator(data) {       for(i in data){                 yield data[i];         }     }         function runPull() {         var obj = it.next();         var val;         console.log("RunPull Clicked",obj);         if(!obj.done) {             val = obj.value;             val.click();             setTimeout(function(){                 runPull();             },200);         }     }     ru...
Post a Comment
Read more