用SQL语句实现：当A列大于B列时选择A列否

Question

如题所述

Answer 1

Select Case When A>B Then A Else B End From 表

Answer 2

select
case
when first_name>middle_name then
case when first_name>last_name then first_name
else last_name end
else
case when middle_name>last_name then middle_name else last_name
end
end as name
from member本回答被网友采纳