Populate the table Department with data from table dept. Including only required columns.

Q. Populate the table Department with data from table dept. Including only required columns.

Answer =

Insert into Department
Select id, name from dept ;