MySql分页
select * from tableName where 条件 limit m,n;
limit第一个参数是起始位置,第二个参数是取的条数
PS:默认从0开始,上面代码的意思是从m-1的位置开始,取n条数据
Oracle分页
SELECT * FROM ( SELECT A.*, ROWNUM RN
FROM (SELECT * FROM tableName where 条件) A WHERE ROWNUM <= 20 ) WHERE RN >= 11
PS:
SELECT * FROM tableName where 条件 根据条件进行数据库的查询
<pre name="code" class="html"><pre name="code" class="html">SELECT A.*, ROWNUM RN
FROM (SELECT * FROM tableName where 条件) A WHERE ROWNUM <= 20 )
从按照条件查询出来的数据中取出
ROWNUM<=20的数据
<pre name="code" class="html"><pre name="code" class="html">SELECT * FROM ( SELECT A.*, ROWNUM RN
FROM (SELECT * FROM tableName where 条件) A WHERE ROWNUM <= 20 ) WHERE RN >= 11
把按照条件查询出来的数据中取出 <pre name="code" class="html">ROWNUM<=20的数据作为范围,然后从里面取出<pre name="code" class="html"><pre name="code" class="html">RN <span style="font-family: Arial, Helvetica, sans-serif;">>=11的数据(RN为第二次查询后给</span><span style="font-family: Arial, Helvetica, sans-serif;">ROWNUM起的别名</span><span style="font-family: Arial, Helvetica, sans-serif;">)</span>