当使用between start and end进行分页时 无法直接展示出list的数量返回给前端,可以在 rownum as rn 后面增加 COUNT(*)OVER() AS TOTAL 查询出数据总数
例:
SELECT * FROM(
SELEC rownum rn,COUNT(1)OVER() AS TOTAL,*
FROM db
)AS A WHERE A.rn BETWEEN 100 AND 200
当使用between start and end进行分页时 无法直接展示出list的数量返回给前端,可以在 rownum as rn 后面增加 COUNT(*)OVER() AS TOTAL 查询出数据总数
例:
SELECT * FROM(
SELEC rownum rn,COUNT(1)OVER() AS TOTAL,*
FROM db
)AS A WHERE A.rn BETWEEN 100 AND 200