152k views
19 votes
Choose the correct qurey to remove a record with names "John" in the persons table

(a) Delete from persons where name="John";(b) Delete from table1 where name="John";(c) Delet from persons where name="John";(d) Delet from persons where name="Alex";

User Rootless
by
4.6k points

1 Answer

1 vote

Answer:

a

Step-by-step explanation:

The correct syntax would be:

DELETE FROM persons WHERE name='John'

i.e., use single quotes. Uppercase keywords is not required but preferred by many.

User Tijagi
by
4.4k points