22,209
社区成员
发帖
与我相关
我的任务
分享
转换下
cast(字段 as int)
--
A.NAME是varchar?
A.NAME/200
select × from
(
SELECT A.NAME , (A.NAME / 200) AS Y ,(A.NAME - FLOOR(A.NAME/200)*200) AS X FROM METAATTR A, METAATTRCLS B
WHERE A.MASTERI=B.ERI AND B.CODE='0001' and isnumeric(a.name)=1
)C WHERE X>20 ORDER BY Y DESC