select drivername as 司机姓名, Sum(case when categoryname='急减速' then cishu else 0 end) as '急减速' Sum(case when categoryname='急加速' then cishu else 0 end) as '急加速' from t group by drivername
表明: driv;select a.drivername,a.cishu 急减速,b.cishu 急加速 from (select drivername,cishu from driv where categoryname='急减速') a,(select drivername,cishu from driv where categoryname='急加速') b where a.drivername = b.drivername
Sum(case when categoryname='急减速' then cishu else 0 end) as '急减速'
Sum(case when categoryname='急加速' then cishu else 0 end) as '急加速'
from t
group by drivername