SQL SELECT INTO - Overview, syntax

SQL SELECT INTO - Introduction and syntax 

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL SELECT INTO statement. Write SQL syntax for the SQL SELECT INTO statement along with an example.

SQL SELECT INTO: The SELECT INTO statement selects data from one table and inserts it into a different table. Used often for creating back up’s.

Syntax:
SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename

Example:
SELECT * INTO employee_Backup FROM employee

SQL MINUS

SQL MINUS returns all rows in the first query that are not returned in the second query..................

SQL HAVING

HAVING clause is used to specify some condition along with aggregate functions............

SQL CONCATENATE

SQL CONCATENATE: This clause combine together (concatenate) the results from several different fields...............

SQL INTERSECT

SQL INTERSECT allows combining results of two or more select queries. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results..............

SQL GROUP BY

GROUP BY: It is used with aggregate functions to group the result-set by one or more columns................

<<Previous  Next>>