SELECT * FROM (SELECT ROWNUM AS ADODB_ROWNUM,COMPANYNAME,MESSAGECODE,ENGAGETYPE,ISSUEMODE,ISSUEDATE,WORKPLACE,ENGAGENUM FROM jy_user.VIEW_EMPLOYINFO3 WHERE ROWNUM <= ".$offset." ORDER BY ISSUEDATE DESC) WHERE ADODB_ROWNUM > ".(($page-1)*$pagesize)没有Limit,只有ROWNUM,实现分页可以参考以上代码!
有top 和 rownum
只能用ROWNUM