取数据库表中每一行的两个字段的较小值

xiaoxiao2021-02-27  420

直接上代码:

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;

转载请注明原文地址: https://www.6miu.com/read-4343.html

最新回复(0)