select usrid,
max(case info when temp1 then data else 0 end) as temp1,
max(case info when temp2 then data else 0 end) as temp2,
max(case info when temp3 then data else 0 end) as temp3,
max(case info when tempx then data else 0 end) as tempx
from table2
group by usrid;
max(case info when temp1 then data else 0 end) as temp1,
max(case info when temp2 then data else 0 end) as temp2,
max(case info when temp3 then data else 0 end) as temp3,
max(case info when tempx then data else 0 end) as tempx
from table2
group by usrid;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货