SELECT * FROM ms_realdata r WHERE r.terminalno='56020004' ORDER BY CAST(r.dataitemno AS INT) ASC;
oracle中将字符串转换为i数值类型
最新推荐文章于 2021-04-09 11:06:46 发布
SELECT * FROM ms_realdata r WHERE r.terminalno='56020004' ORDER BY CAST(r.dataitemno AS INT) ASC;