以下是引用tlliqi在2014-4-29 11:48:28的发言:
你就说取横的3个值的最小值
还不能这么说,
调试成功!只要这样:
select min(d) as mind as from (select min(a) as d from table union all select min(b) as d from table union all select min(c) as d from table) AS derivedtbl_1
思路:先取出三个字段的各最小值并成一个表(derivedtbl_1)字段为D,再取出这个字段的最小值。
[
本帖最后由 lgp740401_72 于 2014-4-29 12:24 编辑 ]