[color=red]首先是oracle [/color]
select * from
(select rownum num,t.* from
(select empno,sal from emp order by sal) t)
where num between 6 and 10;
[color=red]Mysql 的分页[/color]
select * from test_table limit 100,10 ;
select * from
(select rownum num,t.* from
(select empno,sal from emp order by sal) t)
where num between 6 and 10;
[color=red]Mysql 的分页[/color]
select * from test_table limit 100,10 ;