The SQL Delete command deletes one or more records from the database. The set of records involved are taken by the WHERE clause.

    DELETE FROM <Class>|cluster:<cluster>|index:<index> [<Condition>*](WHERE) [BY <Fields>* [ASC|DESC](ORDER)*] [<MaxRecords>](LIMIT)

The WHERE clause is common to the other SQL commands.

Delete all the records with surname equals to 'unknown' ignoring the case:

    delete from Profile where surname.toLowerCase() = 'unknown'

To know more about other SQL commands look at SQL commands.