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区别在哪里?