[color=red]Oracle[/color]:
select b.* from
(
select rownum r , t.* from table_name(表名) t
) b where b.r> BEGIND_COUNT(开始条数) and b.r<= END_COUNT(结束条数)
[color=red]Mysql[/color]:
Select * from table_name(表名) limit size(数据条数) offset startnum(开始条数)
[color=red]Sybase[/color]:
Select top size(数据条数) start at startnum(开始条数) * from table_name(表名)
select b.* from
(
select rownum r , t.* from table_name(表名) t
) b where b.r> BEGIND_COUNT(开始条数) and b.r<= END_COUNT(结束条数)
[color=red]Mysql[/color]:
Select * from table_name(表名) limit size(数据条数) offset startnum(开始条数)
[color=red]Sybase[/color]:
Select top size(数据条数) start at startnum(开始条数) * from table_name(表名)