Orcle:
Select tt,* from(select cc.*,rownum rn from(select * from 表名 where 条件
)tt where rownum<=10 )cc where rn>=1
Mysql:
select * from 表名 where 条件 limit 0,10
Orcle数据库得成长之路MySQL/Orcle分页查询数据 Orcle: Select tt,* from(select cc.*,rownum rn from(select * from 表名 where 条件 )tt where rownum&amp;amp;lt;=10 )cc where rn&amp;amp;gt;=1 Mysql: select * from 表名 where 条件 limit...