select * from (select Z_YXJK_DMDH.*, rownum as rid from Z_YXJK_DMDH where rownum<=10) where rid > 1 或者 select * from Z_YXJK_DMDH where rownum<=10 minus select * from Z_YXJK_DMDH where rownum=1
<sql>select YWLX,RQ,PCH,SFBZ,YHBM from ZB_CZFSBWML where ZT='0' and rownum>=10 order by YWLX</sql> 这样就可以解析的到的
<sql>select YWLX,RQ,PCH,SFBZ,YHBM from ZB_CZFSBWML where ZT='0' and rownum<=10 order by YWLX</sql>
这句的rownum<=10 解析不了,如何转换呢?
或者你改成10 〉= rownum实时
或者
select * from Z_YXJK_DMDH where rownum<=10
minus
select * from Z_YXJK_DMDH where rownum=1