Kuris sakinys įterpia darbuotojų duomenis į „HR“ ir „Payroll“ lenteles, jei darbuotojo pareigos yra „Manager“?

Question

Accepted Answer

INSERT ALL INTO HR VALUES ('Jonas', 'Manager') INTO Payroll VALUES ('Jonas', 'Manager') SELECT * FROM Employees WHERE job_id = 'Manager';

Answer

INSERT FIRST INTO HR VALUES ('Jonas', 'Manager') SELECT * FROM Employees;

Answer

INSERT ALL INTO HR ('Manager') INTO Payroll ('Manager') SELECT * FROM Employees;

Answer

INSERT INTO HR, Payroll VALUES ('Jonas', 'Manager') SELECT * FROM Employees WHERE job_id = 'Manager';

Crowdly