Computer scienceSoftware development foundationsSQL and databasesSQL basicsData Modification Language

Basic DELETE statement

Complete the query

Report a typo

Complete the query that removes records from the staff table where salary is higher than 40000 and experience is less than 10:

DELETE FROM staff
...

Select one option from the list

WHERE salary > 40000 AND experience < 10

WHERE salary < 40000 AND experience < 10

WHERE salary > 4000 AND experience < 10

IF salary > 40000 AND experience < 10

Create a free account to access the full topic