1.Oracle 分页
SELECT * FROM
( SELECT A.* , rownum r
FROM
( SELECT * FROM msr_topic
Where name like %hr%
) A
WHERE rownum <= indexEnd
) B
WHERE r > indexStart;
2.SqlServer 分页
Select * from
( select * , ROW_NUMBER( )over( order by u_id ) as row_id
from users
where u_name like %hr%
) as temp_users
Where row_id between ${start} and ${end}
3.mysql分页
select * from table limit start , counts
SELECT * FROM
( SELECT A.* , rownum r
FROM
( SELECT * FROM msr_topic
Where name like %hr%
) A
WHERE rownum <= indexEnd
) B
WHERE r > indexStart;
2.SqlServer 分页
Select * from
( select * , ROW_NUMBER( )over( order by u_id ) as row_id
from users
where u_name like %hr%
) as temp_users
Where row_id between ${start} and ${end}
3.mysql分页
select * from table limit start , counts