Order by 排序问题
mysql:
select * from 'cms_article' order by cast(sort as binary) asc;
Oracle:
order by to_number(sort) ASC;
sqlserver:
order by convert(int,sort) ASC或者order by cast(sort as int) ASC
posted on 2020-12-30 16:56 Asura&Angle 阅读(210) 评论(0) 编辑 收藏 举报