1、Oracle:
select
case
when A>B then A
else
case
when B>C then B
else
C
end
end
from
tableName;
2、mysql
select
if(A>B,A,
if(B>C,B,C)
)
from
tableName;
1、Oracle:
select
case
when A>B then A
else
case
when B>C then B
else
C
end
end
from
tableName;
2、mysql
select
if(A>B,A,
if(B>C,B,C)
)
from
tableName;