The SQL SELECT INTO statement is a Sybase extension that can be used to insert the results of a query into a table (or a variable, depending on the DBMS).
Tag: what is
SQL INSERT INTO… SELECT Examples
The SQL INSERT statement is most commonly used to insert individual rows into a table.
But you can also insert the results of a query into a table. This means that you can insert multiple rows at once (as long as they’re returned by the query).
Continue readingSQL Self Join
This article provides an overview of the self join in SQL, as well as a basic example.
Continue readingSQL Natural Join
This article provides an overview of the natural join in SQL, as well as some basic examples.
Continue readingSQL Full Join
This article provides an overview of the FULL JOIN in SQL, as well as some basic examples.
SQL Cross Join
This article provides an overview of the CROSS JOIN in SQL, as well as some basic examples.
SQL Left Join
This article provides an overview of the LEFT JOIN in SQL, as well as some basic examples.
SQL Inner Join
This article provides an overview of the INNER JOIN in SQL, as well as some basic examples.
SQL Right Join
This article provides an overview of the RIGHT JOIN in SQL, as well as some basic examples.
SQL Alias Explained
The SQL alias is a nice little feature of SQL that allows you to write more concise code and create column names when no column name exists.
There are two SQL alias types; column aliases, and table aliases. In this article, I provide an overview of both.
Continue reading