1.09 限制返回的行数

mysql> select empno,ename from emp order by empno;
+-------+--------+
| empno | ename  |
+-------+--------+
|  7369 | SMITH  |
|  7499 | ALLEN  |
|  7521 | WARD   |
|  7566 | JONES  |
|  7654 | MARTIN |
|  7698 | BLAKE  |
|  7782 | CLARK  |
|  7788 | SCOTT  |
|  7839 | KING   |
|  7844 | TURNER |
|  7876 | ADAMS  |
|  7900 | JAMES  |
|  7902 | FORD   |
|  7934 | MILLER |
+-------+--------+
14 rows in set (0.00 sec)

mysql> select empno,ename from emp order by empno limit 2,2;
+-------+-------+
| empno | ename |
+-------+-------+
|  7521 | WARD  |
|  7566 | JONES |
+-------+-------+
2 rows in set (0.00 sec)

mysql> select empno,ename from emp order by empno limit 3,2;
+-------+--------+
| empno | ename  |
+-------+--------+
|  7566 | JONES  |
|  7654 | MARTIN |
+-------+--------+
2 rows in set (0.00 sec)

mysql> select empno,ename from emp order by empno limit 3;
+-------+-------+
| empno | ename |
+-------+-------+
|  7369 | SMITH |
|  7499 | ALLEN |
|  7521 | WARD  |
+-------+-------+
3 rows in set (0.00 sec)

转载于:https://www.cnblogs.com/liang545621/p/7518448.html