SQL: SUM Felder zu lang

[Fuerchau]

Auch das geht mittels CTE's:

with
mySums as (select f1, f2, sum(f3) as f3 from myfile group by f1, f2)
select f1, f2, f3 from mysums
union
select min('Z'), min('Z'), sum(f3) as f3 from mysums