方法1：
select min(c) from (select min(b) as c from tab_nameunionselect min(a) as c from tab_name);
方法2：
select least(min(A),min(B)) from table; least(...),greatest(...)中如果含有null的话，无法得到结果select greatest(max(A),max(B)) from table;
本文共 227 字，大约阅读时间需要 1 分钟。
方法1：
select min(c) from (select min(b) as c from tab_nameunionselect min(a) as c from tab_name);
方法2：
select least(min(A),min(B)) from table; least(...),greatest(...)中如果含有null的话，无法得到结果select greatest(max(A),max(B)) from table;
转载地址：http://jplkx.baihongyu.com/