SELECT * FROM (SELECT T.*, ROWNUM ROWNUM_ FROM (SELECT * FROM T_LOG_INFO WHERE 1 = 1) T WHERE ROWNUM <= 15510) WHERE ROWNUM_ > 15500?SELECT * FROM (SELECT T.*, ROWNUM RN FROM T_LOG_INFO_BUSI T WHERE ROWNUM < 15510) WHERE RN >= 15500;网上写分页包括hibernate自动分页都是采用上面的语句分页,这两句SQL区别在哪里?
?