SQl server分页:
select top 10 * form table1 where indexID not in (select top 20 indexID from table1 )
Oracle分页:
select * from(select rownum r,* from(select * from table1) where rownum<20) where r>10
MySQL分页
select * from tablename limit 5,10--返回第5至10条记录
select top 10 * form table1 where indexID not in (select top 20 indexID from table1 )
Oracle分页:
select * from(select rownum r,* from(select * from table1) where rownum<20) where r>10
MySQL分页
select * from tablename limit 5,10--返回第5至10条记录
扫一扫
199
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
