SQL “Select Into” Statement Usage Tutorial
SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how to use Select Into SQL statement for different cases. Syntax Select Into statement syntax is the same as with Select syntax. We just need to a INTO between SELECT and FROM. We can also use WHERE statement in order to filter rows.
|
1 |
SELECT columns INTO newtable [IN externaldb] FROM oldtable WHERE condition; |
...
