# deleteWhere

inline fun <T : Table> T.deleteWhere(limit: Int? = null, op: T.(ISqlExpressionBuilder) -> Op<Boolean>): Int

Represents the SQL statement that deletes only rows in a table that match the provided op.

#### Return

Count of deleted rows.

#### Parameters

limit

Maximum number of rows to delete.

op

Condition that determines which rows to delete.

#### Samples

org.jetbrains.exposed.sql.tests.shared.dml.DeleteTests.testDelete01

fun <T : Table> T.deleteWhere(limit: Int? = null, offset: Long? = null, op: T.(ISqlExpressionBuilder) -> Op<Boolean>): Int

### Deprecated

This `offset` parameter is not being used and will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-550/DeleteStatement-holds-unused-offset-property) with a use-case if your database supports the OFFSET clause in a DELETE statement.

#### Replace with

    deleteWhere(limit) { op.invoke() }

Content copied to clipboard