SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM T33_CARINSURANCE_ORDER) A
WHERE ROWNUM <= 10
)
WHERE RN >= 5;
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM T33_CARINSURANCE_ORDER) A ) WHERE RN BETWEEN 5 AND 10;
SELECT rownum, t.* FROM T33_CARINSURANCE_ORDER t WHERE ROWNUM<=10
minus
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM T33_CARINSURANCE_ORDER) A
WHERE ROWNUM <= 10
)
WHERE RN >= 5;
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM T33_CARINSURANCE_ORDER) A ) WHERE RN BETWEEN 5 AND 10;
SELECT rownum, t.* FROM T33_CARINSURANCE_ORDER t WHERE ROWNUM<=10
minus
SELECT rownum, t.* FROM T33_CARINSURANCE_ORDER t WHERE ROWNUM<=5;
上面这个可能在JAVA代码里不行。
hibnate 解决办法如下
Query query = session.createQuery(queryString);
query.setFirstResult( Integer.parseInt(sDate));
query.setMaxResults(Integer.parseInt(eDate) - Integer.parseInt(sDate));