Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Inserting selected rows

Syntax is important

Report a typo

Select all syntactically correct queries.

Select one or more options from the list

INSERT INTO employees (name) SELECT name FROM candidates

INSERT INTO employees SELECT * FROM candidates

INSERT INTO employees SELECT * FROM candidates WHERE id = 1

INSERT INTO employees FROM candidates WHERE name = 'John Smith'

___

Create a free account to access the full topic