In this article, we will learn how to write a SQL select into query.

To copy data from one table into a new table in SQL, the SELECT INTO statement is used.

Using SELECT INTO statement the new table will be created with the column-names and types as defined in the old table. We can create new column names using the AS clause (Aliases).

Syntax

SELECT column_name(s)
INTO NEW_TABLE [IN EXTERNAL_DB]
FROM OLD_TABLE;

Example-1

The subsequent statement would create a backup copy of Articles:

SELECT * INTO Backup_Article
FROM Article;

Example-2

The subsequent statement would use the IN clause to copy the table into a new table in another database:

SELECT * INTO Backup_Article IN 'Backup.mdb'
FROM Article;

 

Also, check How To Use ANY, ALL Operators In SQL