What does the LIMIT clause do in a query?

What does the LIMIT clause do in a query?

• A. Sorts the result set by a column
• B. Filters rows based on a condition
• C. Limits the number of rows returned
• D. Joins rows from two tables

Answer: (C)

The LIMIT clause controls how many rows the query returns. It sets an upper bound on the result set, so you get at most the specified number of rows—useful for previews or paging through results. For example, selecting from a table with LIMIT 10 will return up to ten rows, even if there are many more in the table. It doesn’t sort results (that’s ORDER BY), filter rows (that’s WHERE), or combine rows from multiple tables (that’s JOIN). Some databases offer variations like LIMIT with OFFSET or other syntax, but the core idea is to cap the number of rows produced.

The LIMIT clause controls how many rows the query returns. It sets an upper bound on the result set, so you get at most the specified number of rows—useful for previews or paging through results. For example, selecting from a table with LIMIT 10 will return up to ten rows, even if there are many more in the table. It doesn’t sort results (that’s ORDER BY), filter rows (that’s WHERE), or combine rows from multiple tables (that’s JOIN). Some databases offer variations like LIMIT with OFFSET or other syntax, but the core idea is to cap the number of rows produced.