mysql中sum和union_在MySql中使用UNION的SUM,COUNT

试试这个

SELECT DATA ,CAUSE , TOT_TIME , N_RIPET_CAUSE

FROM ( select DATA, CONCAT(`CAUSE_1`,' ',`CAUSE_2`, ' ', `CAUSE_3`) as CAUSE ,

sum(`TIME_1` + `TIME_2` +`TIME_3`) as TOT_TIME ,

(count(`CAUSE_1`)+count(`CAUSE_2`)+count(`CAUSE_3`)) as N_RIPET_CAUSE

FROM your_table

group by DATA

) t

编辑.

试试这个

( select DATA , `CAUSE_1` as CAUSE ,

sum(`TIME_1` + `TIME_2` +`TIME_3`) as TOT_TIME ,

(count(`CAUSE_1`)+count(`CAUSE_2`)+count(`CAUSE_3`)) as N_RIPET_CAUSE

FROM Table1

group by DATA)

union all

(select DATA , `CAUSE_2` as CAUSE ,

sum(`TIME_1` + `TIME_2` +`TIME_3`) as TOT_TIME ,

(count(`CAUSE_1`)+count(`CAUSE_2`)+count(`CAUSE_3`)) as N_RIPET_CAUSE

FROM Table1

group by DATA )

union all

(select DATA , `CAUSE_3` as CAUSE ,

sum(`TIME_1` + `TIME_2` +`TIME_3`) as TOT_TIME ,

(count(`CAUSE_1`)+count(`CAUSE_2`)+count(`CAUSE_3`)) as N_RIPET_CAUSE

FROM Table1

group by DATA )

编辑：

根据您的需要尝试这个

select cause, sum(time) Tot_time, count(cause) N_Ripet_Cause

from(

select cause_1 as cause, time_1 as time

from Table1

union all

select cause_2 as cause, time_2 as time

from Table1

union all

select cause_3 as cause, time_3 as time

from Table1

) t

group by cause