mysql combine every rows in group by -


i have table this:

id   weekday   money   rank --------------------------- 1    0         20      1 2    1         30      1 3    2         40      1 4    3         50      1 5    4         60      1 6    5         70      1 7    6         80      1

i want result:

rank   sun   mon   tue   wed   thu   fri   sat ---------------------------------------------- 1      20    30    40    50    60    70    80

my query far:

select rank,     case when weekday = 0 money end 'sun',     case when weekday = 1 money end 'mon',     case when weekday = 2 money end 'tue',     case when weekday = 3 money end 'wed',     case when weekday = 4 money end 'thu',     case when weekday = 5 money end 'fri',     case when weekday = 6 money end 'sat' weekday group rank

this query shows sun money. how can modify mysql query required result?

please check :

select rank,sum(sun) sun,          sum(mon) mon,sum(tue) tue,          sum(wed) wed, sum(thu) thu ,         sum(fri) fri, sum(sat) sat               (select rank,              case when weekday = 0 money end 'sun',              case when weekday = 1 money end 'mon',              case when weekday = 2 money end 'tue',              case when weekday = 3 money end 'wed',              case when weekday = 4 money end 'thu',              case when weekday = 5 money end 'fri',              case when weekday = 6 money end 'sat'          weekday rank =1)      tbl2     group rank

Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more