Define select into statement in SQL

The SELECT INTO statement is used to select data from a database table and to insert it to a different table at the same time.

Example :

Select * into Departments from Employees

This Query will select data from “Employees” table and insert into “Departments.