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

Custom Sorting Array List in PHP

 <?php $order = array("Z","Srilanka","34", "Canada", "India", "USA"); $array = array(     array('id' => 7867867, 'title' => 'USA'),     array('id' => 3452342, 'title' => 'India'),     array('id' => 1231233, 'title' => 'Srilanka'),     array('id' => 5867867, 'title' => 'Z'), ); usort($array, function ($a, $b) use ($order) {     $pos_a = array_search($a['title'], $order);     $pos_b = array_search($b['title'], $order);     return $pos_a - $pos_b; }); print_r($array); ?>
Post a Comment
Read more

simple recursive function to copy entire directories

<?php function recurse_copy ( $src , $dst ) {     $dir = opendir ( $src );     @ mkdir ( $dst );     while( false !== ( $file = readdir ( $dir )) ) {         if (( $file != '.' ) && ( $file != '..' )) {             if ( is_dir ( $src . '/' . $file ) ) {                 recurse_copy ( $src . '/' . $file , $dst . '/' . $file );             }             else {                 copy ( $src . '/' . $file , $dst . '/' . $file );             }         }     }     closedir ( $dir ); } ?>
Post a Comment
Read more