oracle 分页查询sql语句

SQL: 分页查询

SELECT * FROM 
(
SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM tablenamewhere filed like '%西贝%' order by filed1 desc) A 
WHERE ROWNUM <= 60
)
WHERE RN >= 0

conut  总条数

select count(*) count from table where field like '%西贝%' 

 

posted @ 2020-04-15 10:38  西贝小小凤  阅读(243)  评论(0编辑  收藏