my sql分页
select * from userdetail where userid limit 0,20
SQLServer分页
select
top
10 *
from
table1
where
id
not
in
(
select
top
开始的位置 id
from
table1)
oracle分页
SELECT * FROM ( SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 40 ) WHERE RN >= 21
其中最内层的查询SELECT * FROM TABLE_NAME表示不进行翻页的原始查询语句。ROWNUM <= 40和RN >= 21控制分页查询的每页的范围