Choose all the correct options

Question

given the following table:current_employees--------------------------empid integer not nullname char(20)salary decimal(10,2)past_employees--------------------------empid integer not nullname char(20)salary decimal(10,2)assuming both tables contain data, which of the following statements will not successfully add data to table current_employees?

Accepted Answer

INSERT INTO current_employees (name, salary) VALUES (SELECT name, salary FROM
past_employees WHERE empid = 20)

Answer

INSERT INTO current_employees (empid) VALUES (10)

Answer

INSERT INTO current_employeesVALUES (10, 'JAGGER', 85000.00)

Answer

INSERT INTO current_employees SELECT empid, name, salary FROM past_employees WHERE
empid = 20

0 Discussions

Trending Exams