sql nvchar 取数字按数字排序

时间:2017.4.21 编辑: 叶建勇 阅读量:2624 全屏

 
SELECT TOP 10000 *
  FROM 表格  where  shenhe_order >=10 order by  kaoshi_kaodian,  cast(cast( replace(replace( replace(kaoshi_kaochang,'第',''),'试场','') ,' ','') as char(2)) as int)  ,cast(kaoshi_zuoweihao  as int)