mysql技巧

SELECT id,is_deleted,position,1/position as p,status FROM application.view_entry order by p desc;、//正序排序把0放到最后面