mysql - Get data from table by County in a single row -

-

i want data table in single row single county. right shown in images shows different rows single county kalamazoo. should show single both records in single row.

i using following query

select county, virus, sumofpositivetests  statewisedata  state = 'michigan'

enter image description here

i want results shown following

county        virus        sumofpositivetests --------------------------------------------- kalamazoo     h3n2,h3n8      3

total sum of both h3n2 , h3n8

use mysql group_concat

the following mysql statement return list of comma(,) separated 'virus's each group of 'county' statewisedata table

select county,group_concat(virus),sum(sumofpositivetests) statewisedata  state='michigan' group county

Comments

Post a Comment

Popular posts from this blog

ios - Is 'init' forbidden as *part* of a variable name? -

-
i spent 3 hours debugging error , in end narrowed down (i think) variable name. i using initmonths (initial months) caused unpredicatable errors when changed imonths worked! i can understand preventing use of init on it's own surprised if prevented part of variable name. bug or feature? it's not bug if it's related name being overlap. there's part of arc used know when retain counts should updated, , may running that. similar rules apply use new @ start of names (for same reason). it's easy , wise steer clear of using init @ start of names unless it's init function. i can imagine issue related arc getting involved shouldn't , takes while called shouldn't, weird. i expect issue else , name change had other effect. worst case means have memory issue , changing name has changed memory footprint of code you've moved bug somewhere else (or along lines).
Read more

angular - Angular2 Router: Cannot find primary outlet to load 'HomeComponent' -

-
tried switch new router in version "@angular/router": "3.0.0-beta.2" in combination "@angular/*": "2.0.0-rc.4", following official docs on componentrouter. however, i'm facing issue when trying load app default homecomponent: cannot find primary outlet load 'homecomponent' it seems has using templateurl , external html file instead of using inline template style. homecomponent not shown in window , error printed console. however, when use link home component gets shown second hand. as change from templateurl: 'home.html' to template: '<router-outlet></router-outlet>' error gone, homecomponent shown , routing works expected. is known issue? work using templateurl? there have respect work? the problem was, due app loading screen, <router-outlet></router-outlet> did not exist yet, due race condition. if need hide html part containing outlet, use [hidden] instead o...
Read more

qt - Microsoft FTP Service 451 The parameter is incorrect -

-
i'm trying write ftp client. have 2 ftp servers. first server standard ftp server microsoft. second server written in organization work. program second server works well. program first server receives error: "451 parameter incorrect". can wrong? use qt 4.8.4, windows 7. ... switch(cod) { case 220: user=sett.value("userftp",qstring("anonymous")).tostring(); logmessage(codec1->tounicode("Авторизация пользователя ")+user); buf = qbytearray::fromrawdata("user ",5) + "\n"; sock->write(buf); logmessage(buf); break; ... i have found bug. used ascii. had use latin 1.
Read more