Question

如何用sql实现两列max值中取max值

Answer 1

select case when max(col1)>max(col2) then max(col1) else max(col2) end as max_max

from table_Test;