Querying rows by index in S3 Select

With mysql the following code:

SELECT * from TABLE limit 5, 10 

would pull the 5th through 10th rows of the table. What is the equivalent for doing this through the SQL engine in S3 select (PrestoDB I believe)? Is there a rownumber constructor or operator that works with S3 select?

Answer

The S3 Select documentation is at: SQL Reference for Amazon S3 Select and Amazon Glacier Select – Amazon Glacier

The LIMIT clause is documented as:

LIMIT number

The LIMIT clause limits the number of records that you want the query to return based on number.

So, not available.