New Features

MaxCompute - Supports LIMIT and OFFSET Clauses

Oct 28 2019

MaxCompute SQL now supports the LIMIT and OFFSET clauses for more flexible user operations.

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.

7th Gen ECS Is Now Available

Increase instance computing power by up to 40% and Fully equipped with TPM chips.
Powered by Third-generation Intel® Xeon® Scalable processors (Ice Lake).

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.