SELECT INTO

SELECT INTO is a SQL statement in the SELECT Queries category. Creates a new table from a SELECT query result. Useful for backups or temp tables. The syntax is SELECT columns INTO new_table FROM source_table WHERE condition;. It returns new table with data. A typical example: SELECT * INTO employees_backup FROM employees; -- Creates employees_backup table with all data SELECT name, salary INTO high_earners FROM employees WHERE salary > 80000; -- Creates high_earners with filtered data A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table. A close relative is SELECT DISTINCT, which returns only distinct (unique) values from the specified columns. More about this category: Core SELECT query clauses — SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Related SELECT Queries entries: SELECT, SELECT *, SELECT DISTINCT, WHERE, AND / OR / NOT, IN, BETWEEN, LIKE.