LIMIT 语句
Batch
LIMIT
clause constrains the number of rows returned by the SELECT
statement. In general, this clause is used in conjunction with ORDER BY to ensure that the results are deterministic.
The following example selects the first 3 rows in Orders
table.
SELECT *
FROM Orders
ORDER BY orderTime
LIMIT 3