oracle中varchar字段排序
- oracle中varchar字段排序需要转换数据类型
sql select * from (select mobnum,servicecode,orderid from table1 where orderid > 100 order by cast(orderid as int)) where rownum <= 100
sql select * from (select mobnum,servicecode,orderid from table1 where orderid > 100 order by cast(orderid as int)) where rownum <= 100