LIMIT and OFFSET clauses in Apache Drill are used for controlling the number of records returned by a query. The primary difference between them lies in their functionality.
The LIMIT clause restricts the maximum number of rows returned by a query. It is useful when you need to retrieve only a specific number of records, such as displaying top 10 results or paginating data. For example:
SELECT * FROM employees LIMIT 10;
This query returns the first 10 rows from the “employees” table.
On the other hand, the OFFSET clause specifies the starting point for returning rows. It is often used with LIMIT for pagination purposes. For instance:
SELECT * FROM employees LIMIT 10 OFFSET 20;
This query skips the first 20 rows and then returns the next 10 rows from the “employees” table.
