写法1
select
case when a>b
then a
else b
end as result
from g ;
写法2
select * from (
select a as result from g where a > b
union
select b as result from g where b > a )
select
case when a>b
then a
else b
end as result
from g ;
写法2
select * from (
select a as result from g where a > b
union
select b as result from g where b > a )