将null排在最后
order by if(isnull(level), 99999, level) asc
将0排在最后
1.Order BY表达式 SELECT nian ,gz from Tbl ORDER BY gz!=0 desc,gz asc 2.算术法 SELECT nian ,gz,1/gz as od from Tbl ORDER BY od desc
将null排在最后
order by if(isnull(level), 99999, level) asc
将0排在最后
1.Order BY表达式 SELECT nian ,gz from Tbl ORDER BY gz!=0 desc,gz asc 2.算术法 SELECT nian ,gz,1/gz as od from Tbl ORDER BY od desc
最新评论: