Asura&Angle

导航

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编辑  收藏  举报