SQL SELECT INTO - Overview, syntax

          

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>>



Write your comment - Share Knowledge and Experience


 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring