MySQL 排序时如何把0放最后, 其它按照从小到大排序

SELECT * FROM banner ORDER BY CASE when sort<>0 then sort else 99999 end asc;
SELECT * FROM banner ORDER BY CASE when sort<>0 then sort else 99999 end desc;

SELECT * FROM banner ORDER BY sort = 0,sort asc;
SELECT * FROM banner ORDER BY sort = 0,sort desc;

上面两种方法都可以的