Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Basic DELETE statement

Complete the query

Report a typo

Complete the query that removes records from table staff that has salary higher than 40000 and experience 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