分页查询sql

select * from (select t.*,rownum no from " + table + " t where scbj=0)where (no>(" + PageNo + "-1)*" + PageSize + " and no<=(" + PageNo + ")*" + PageSize + ")

select * from (select t.*,rownum no from EMST_JC_ZZCJ t where ZZCJ Like '%s%')where (no>(1-1)*20 and no<=(1)*20)

update TB_BZ_CONTENT set MC='名称99',LB=1,WZDZ='名称99',DJS='899 where id=14

转载于:https://www.cnblogs.com/handsomer/p/3678200.html