limit

Same as calling limit(limit, -1)

Adds a LIMIT and optional OFFSET clause to the DELETE statement.

This function restricts the number of rows to be deleted. In SQLite, LIMIT is typically used with ORDER BY to delete a specific subset of rows, such as the oldest or newest entries.

This function can be called only once per DeleteStatement. Subsequent calls will override the previously set LIMIT and OFFSET.

Note: This is a non-standard SQL feature specific to SQLite.

Example:

// Deletes the 10 oldest log entries, skipping the first 5
LogTable.delete()
    .orderBy(LogTable.timestamp, Sort.ASC)
    .limit(10, 5) // Deletes 10 rows starting from the 6th oldest
    .execute()

Parameters

See also