SELECT INTO Statement in SQL

SELECT INTO Statement in SQL is used to copy data from one table to another and it can also be use in create backup of the table.

Here we take an example in which we creates a students_data, this table is used to store the data of students, which has the city jaipur

select fname,city

into students_data

from Students

where city='jaipur'

This statement is also useful when we want to copy the table in an another database

select *

into students_data IN 'Backup.mdb'

from Students