> For the complete documentation index, see [llms.txt](https://sugar-at.gitbook.io/blog-article/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sugar-at.gitbook.io/blog-article/sql/delete.md).

# 4. 删除

```sql
-- 普通删除
DELETE FROM test WHERE hours =40 LIMIT 1 

-- 带子查询删除
DELETE FROM test WHERE hours in (41)

DELETE FROM test WHERE hours not in (select DISTINCT hours from works_on)
```