https://duckdb.org/docs/current/sql/query_syntax/limit
LIMIT and OFFSET Clauses – DuckDB
LIMIT is an output modifier. Logically it is applied at the very end of the query. The LIMIT clause restricts the amount of rows fetched. The OFFSET clause...
limit and offsetclausesduckdb