oracle 分页
参数一传入车辆编号,参数二传入页数,参数三传入每页个数
解释:String start =(pagenum-1)*pagesize+1
例如页数传入1,(1-1)*5+1 =1 起始数据就是为1,每页个数为5,所以开始就是第一行开始
例如页数传入5,(5-1)*5+1=21 起始数据就是为5,每页个数为5,所以开始的第一行就是21
解释:String end = pagenum*pagesize
例如页数传1,他的结束条数就是第5条
1.无ORDER BY排序的写法。(效率最高)
SELECT *
FROM (SELECT ROWNUM AS rowno, t.*
FROM emp t
WHERE hire_date BETWEEN TO_DATE (‘20060501’, ‘yyyymmdd’)
AND TO_DATE (‘20060731’, ‘yyyymmdd’)
AND ROWNUM <= 20) table_alias
WHERE table_alias.rowno >= 10;
2.有ORDER BY排序的写法。(效率较高)
SELECT *
FROM (SELECT tt., ROWNUM AS rowno
FROM ( SELECT t.
FROM emp t
WHERE hire_date BETWEEN TO_DATE (‘20060501’, ‘yyyymmdd’)
AND TO_DATE (‘20060731’, ‘yyyymmdd’)
ORDER BY create_time DESC, emp_no) tt
WHERE ROWNUM <= 20) table_alias
WHERE table_alias.rowno >= 10;