自己写代码来判断
try:
Select (case when T1>=T2 then (case when T1>=T3 then T1 else T3 end) else (case when T2>=T3 then T2 else T3 end) end) from 表
try:
Select (case when T1>=T2 then (case when T1>=T3 then T1 else T3 end) else (case when T2>=T3 then T2 else T3 end) end) from 表
select max(col)from
(
select max(T1) col from tab union
select max(T2) col from tab union
select max(T3) col from tab
)
from
( select max(T1) a from
union
select max(T2) a from
union
select max(T3) a from
)
(
select T1 col from yourtable union
select T2 from yourtable union
select T3 from yourtable
) a
from
(
select T1,t2 from yourtable union all
select T1,t2 from yourtable union all
select T1,t2 from yourtable
) a order by t1 desc