select *,
case when (s01>s02 and s01>s03 and s01>s04 and s01>s05 ) then s01
when (s02>s01 and s02>s03 and s02>s04 and s02>s05 ) then s02
when (s03>s01 and s03>s02 and s03>s04 and s03>s05 ) then s03
when (s04>s01 and s04>s02 and s04>s03 and s04>s05 ) then s04
when (s05>s01 and s05>s02 and s05>s03 and s05>s04 ) then s05
else ''end as 新列
from 表
select 新列=max(S01) from 表
union all
select 新列=max(S02) from 表
union all
select 新列=max(S03) from 表
union all
select 新列=max(S04) from 表
union all
select 新列=max(S05) from 表