直接上代码: select t.Objectid, (Case When t.s_deep>t.e_deep Then t.e_deep Else t.s_deep End) As DeepValue from jsl t;