SELECT * FROM ms_realdata r WHERE r.terminalno='56020004' ORDER BY CAST(r.dataitemno AS INT) ASC;
oracle中将字符串转换为i数值类型
最新推荐文章于 2023-03-23 16:41:28 发布
SELECT * FROM ms_realdata r WHERE r.terminalno='56020004' ORDER BY CAST(r.dataitemno AS INT) ASC;