blob: d664c9eec93a848a74e2dfd0f85661671ad88135 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
$f = ($x)->{return $x+1};
select key,min(num) as num from (
select key,$f(0) as `num` from Input1
union all
select key,$f(1) as `num` from Input2
)
group by key
order by key
|