Does this give the same result and do the optimization you want?
select c1, min(c2) AS c2, min(c3) AS c3, min(c4) AS c4from tgroup by c1;
>