DELETE - Removing Records1 / 10
You can use DELETE to remove a record from a database table. Try:
DELETE FROM sightings WHERE sighting_id = 3;Table sightings
| sighting_id | creature_name | location | year |
|---|---|---|---|
| 1 | Mothman | Point Pleasant | 1966 |
| 2 | Bigfoot | Oregon | 1972 |
| 3 | Mothman | Chicago | 2017 |
| 4 | Chupacabra | Texas | 1995 |
| 5 | Mothman | Ohio | 2020 |
| 6 | Jersey Devil | New Jersey | 1909 |
| 7 | Mothman | West Virginia | 1967 |
No key for < or > on your keyboard? Use these:
Ctrl+Enter to submit
DELETE - Removing Records - Free SQL Practice Online
Practise DELETE - Removing Records with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.