> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DELETE

<a id="sql-dml-delete" />

<a id="sql-delete" />

Deletes records from a table.

```sql title="DELETE Syntax" theme={null}
DELETE
FROM [<schema name>.]<table name>
[WHERE <expression list>]
```

For example, to delete employee with ID `6`:

```sql DELETE Example theme={null}
DELETE
FROM example.employee
WHERE id = 6
```

Subqueries can also be used in the expression list.  To delete all the most
recent hires in each department:

```sql DELETE with Subquery Example theme={null}
DELETE
FROM example.employee b
WHERE hire_date =
    (
        SELECT MAX(hire_date)
        FROM example.employee l
        WHERE b.dept_id = l.dept_id
    )
```