Given table A with <i>id</i> and <i>code</i> colum

Given table A with id and code columns, which SQL statements are correct? Select all that apply.

INSERT INTO A (id, code) (SELECT id,'X' FROM B WHERE name='XXX');

INSERT INTO A (id, code) (SELECT id,"X" FROM B WHERE name='XXX');

INSERT INTO A (id, code) VALUES (SELECT id,'X' FROM B WHERE name='XXX');

INSERT INTO A (id, code) VALUES (SELECT id,"X" FROM B WHERE name='XXX');

Explanation

SIngle quotes are used for string literals in SQL.
VALUES keyword is not used when inserting sub-query results.

sub-queries

Приєднуйся і вивчай SQL

або Дізнайся більше про Тести з SQL онлайн