1 2 3 4 5 6 7 8 9 10 11 12
| create view result as select
field_2
, sum(An) as MoyAnnuel
, sum(T1) as MoyTrim1
, sum(T2) as MoyTrim2
, sum(T3) as MoyTrim3
from (
select field_2, Field_5 as An, 0 as T1, 0 as T2, 0 as T3 from notes where (rowid%4) = 1 union
select field_2, 0 as An, Field_5 as T1, 0 as T2, 0 as T3 from notes where (rowid%4) = 2 union
select field_2, 0 as An, 0 as T1, Field_5 as T2, 0 as T3 from notes where (rowid%4) = 3 union
select field_2, 0 as An, 0 as T1, 0 as T2, Field_5 as T3 from notes where (rowid%4) = 0
) group by field_2 order by field_2; |
Partager