sql limit子句

什么是SQL Where子句？ (What is a SQL Where Clause?)

WHERE子句(和/或IN ， BETWEEN和LIKE ) (The WHERE  Clause (and/or,  IN ,  BETWEEN , and  LIKE ))

The  WHERE  clause is used to limit the number of rows returned.

WHERE子句用于限制返回的行数。

In this case all five of these will be used is a some what ridiculous  WHERE  clause.

在这种情况下，将使用所有这五个荒谬的WHERE子句。

Here is the current full student list to compare to the  WHERE  clause result set:

这是当前的完整学生列表，可与WHERE子句结果集进行比较：

select studentID, FullName, sat_score, rcd_updated from student;

+-----------+------------------------+-----------+---------------------+| studentID | FullName               | sat_score | rcd_updated         |+-----------+------------------------+-----------+---------------------+|         1 | Monique Davis          |       400 | 2017-08-16 15:34:50 ||         2 | Teri Gutierrez         |       800 | 2017-08-16 15:34:50 ||         3 | Spencer Pautier        |      1000 | 2017-08-16 15:34:50 ||         4 | Louis Ramsey           |      1200 | 2017-08-16 15:34:50 ||         5 | Alvin Greene           |      1200 | 2017-08-16 15:34:50 ||         6 | Sophie Freeman         |      1200 | 2017-08-16 15:34:50 ||         7 | Edgar Frank "Ted" Codd |      2400 | 2017-08-16 15:35:33 ||         8 | Donald D. Chamberlin   |      2400 | 2017-08-16 15:35:33 ||         9 | Raymond F. Boyce       |      2400 | 2017-08-16 15:35:33 |+-----------+------------------------+-----------+---------------------+9 rows in set (0.00 sec)

Rows will be presented that…

将显示以下行：

• WHERE  Student IDs are between 1 and 5 (inclusive)

  WHERE学生ID是1和5(含)之间

• OR  studentID = 8

  OR学生ID = 8

Here’s an updated query, where any record that has an SAT score that’s in this list (1000, 1400) will not be presented:

这是一个更新的查询，其中不会显示此列表中(1000，1400)具有SAT分数的任何记录：

select  studentID, FullName, sat_score, recordUpdatedfrom    studentwhere   (studentID between 1 and 5 or studentID = 8)        and        sat_score NOT in (1000, 1400);

+-----------+----------------------+-----------+---------------------+| studentID | FullName             | sat_score | rcd_updated         |+-----------+----------------------+-----------+---------------------+|         1 | Monique Davis        |       400 | 2017-08-16 15:34:50 ||         2 | Teri Gutierrez       |       800 | 2017-08-16 15:34:50 ||         4 | Louis Ramsey         |      1200 | 2017-08-16 15:34:50 ||         5 | Alvin Greene         |      1200 | 2017-08-16 15:34:50 ||         8 | Donald D. Chamberlin |      2400 | 2017-08-16 15:35:33 |+-----------+----------------------+-----------+---------------------+5 rows in set (0.00 sec)

*As with all of these SQL things there is MUCH MORE to them than what’s in this introductory guide.

*与所有这些SQL事物一样，它们比本入门指南中的内容要多得多。

I hope this at least gives you enough to get started.

我希望这至少能给您足够的入门。

Please see the manual for your database manager and have fun trying different options yourself.

请参阅数据库管理员的手册，并尝试自己尝试其他选项，这很有趣。

翻译自:

sql limit子句