MySQL 5.7 LIMIT語句介紹

LIMIT語句可以限制SELECT語句返回的行數(shù)。LIMIT使用1個或2個參數(shù)，參數(shù)必須是非負數(shù)的整數(shù)。

mysql> select * from dept2 order by 1;
+--------+-------+
| deptno | dname |
+--------+-------+
|     10 | A     |
|     20 | B     |
|     30 | C     |
|     40 | D     |
|     50 | E     |
|     60 | F     |
|     70 | G     |
|     80 | H     |
|     90 | I     |
|    100 | J     |
|    110 | K     |
|    120 | L     |
|    130 | M     |
|    140 | N     |
|    150 | O     |
|    160 | P     |
|    170 | Q     |
|    180 | R     |
|    190 | S     |
|    200 | T     |
+--------+-------+
20 rows in set (0.03 sec)

--返回第6-15行

mysql> select * from dept2 order by 1 limit 5,10;
+--------+-------+
| deptno | dname |
+--------+-------+
|     60 | F     |
|     70 | G     |
|     80 | H     |
|     90 | I     |
|    100 | J     |
|    110 | K     |
|    120 | L     |
|    130 | M     |
|    140 | N     |
|    150 | O     |
+--------+-------+
10 rows in set (0.00 sec)

--返回前5行

mysql> select * from dept2 order by 1 limit 5;
+--------+-------+
| deptno | dname |
+--------+-------+
|     10 | A     |
|     20 | B     |
|     30 | C     |
|     40 | D     |
|     50 | E     |
+--------+-------+
5 rows in set (0.00 sec)

mysql> select * from dept2 order by 1 limit 0,5;
+--------+-------+
| deptno | dname |
+--------+-------+
|     10 | A     |
|     20 | B     |
|     30 | C     |
|     40 | D     |
|     50 | E     |
+--------+-------+
5 rows in set (0.00 sec)