Question

Write SQL commands to create the following EMPLOYEE table:

Answer 1

Answer:

CREATE TABLE table_name AS.

SELECT column1, column2,...

FROM old_table_name WHERE ..... ;

The following SQL creates a copy of the employee table.

CREATE TABLE EmployeeCopy AS.

SELECT EmployeeID, FirstName, Email.

FROM Employee;