DataDesk
All topics
INSERT, UPDATE & DELETE — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
INSERT, UPDATE & DELETE
Add, change and remove rows safely.
0
/ 20 solved
All levels
Basic (7)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Insert one row
Basic
2
Insert several rows
Basic
3
Insert into chosen columns
Basic
4
Update one row
Basic
5
Update with a calculation
Basic
6
Delete rows
Basic
7
Update several columns
Basic
8
Fill in missing values
Intermediate
9
Insert from a query
Intermediate
10
Update using another table
Intermediate
11
Delete using another table
Intermediate
12
Conditional update
Intermediate
13
Remove exact duplicates
Intermediate
14
Stock after an order
Intermediate
15
Archive and delete
Intermediate
16
Upsert a price list
Advanced
17
Keep the latest record
Interview
Advanced
18
Salary band correction
Advanced
19
Reassign a manager's team
Advanced
20
Monthly summary table
Interview
Advanced