把varchar转换为int 然后进行排序

 

select * from yourtable order by cast(yourcol as int);

posted @ 2017-09-12 11:05  chang1234  阅读(168)  评论(0)    收藏  举报