Method limit

packages/sql/src/query/QueryBuilder.ts:1990–1999

* Sets a LIMIT clause to restrict the number of results. * * @example * ```ts * qb.select('*').limit(10); // First 10 results * qb.select('*').limit(10, 20); // 10 results starting from offset 20 * ```

(limit?: number, offset = 0)

   * ```
   */
  limit(limit?: number, offset = 0): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs> {
    this.ensureNotFinalized();
    this.#state.limit = limit;

    if (offset) {
      this.offset(offset);
    }

    return this as SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs>;
  }

  /**
   * Sets an OFFSET clause to skip a number of results.