1.[color=red]oracle[/color]
2.[color=red]mysql[/color]
3.[color=red]SQL Server[/color]:
4.[color=red]DB2[/color]
select * from (select *,rownum rm from tableName where rownum>=max) where rm<=min;
2.[color=red]mysql[/color]
select * from tableName limit min,max;
3.[color=red]SQL Server[/color]:
select top @pagesize * from tablename where id not in (select top @pagesize*(@page-1) id from tablename order by id) order by id
4.[color=red]DB2[/color]
select * from (select *,rownumber() as ROW_NEXT from tablename) where ROW_NEXT between min and max