LIMIT clause #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
SELECT * FROM Orders ORDER BY orderTime LIMIT 3