SELECT LIMIT number of rows

Use the LIMIT clause to select the number of records from a result set. Use an integer to specify the number of rows in the result set.

The functionality is based on Apache Spark syntax.

SELECT * FROM object LIMIT number_of_rows