MaxCompute - Supports LIMIT and OFFSET Clauses
Oct 28 2019MaxCompute
Target customers: Alibaba Cloud MaxCompute users. Features released: The ORDER BY, LIMIT, and OFFSET clauses can be used in combination to specify the number of rows to skip before starting to return rows. For example, the SELECT * FROM src ORDER BY key LIMIT 20 OFFSET 10; statement sorts the src table by key in ascending order, and exports rows 11 to 30. OFFSET 10 specifies to skip the first 10 rows, and LIMIT 20 specifies that a maximum of 20 rows can be exported.