In SQL, the IN operator allows you to filter your query results based a list of values.
You can also use it to match any value returned by a subquery (a subquery is a query that’s nested inside another query).
Continue readingTag: what is
SQL LIKE Operator for Beginners
In SQL, the LIKE operator allows you to do pattern matching. It determines whether a specific character string matches a specified pattern.
A pattern can include regular characters and wildcard characters.
Continue readingSQL CREATE TABLE … AS SELECT Statement
The SQL CREATE TABLE ... AS SELECT statement enables you to insert the results of a query into a new table.
SQL SELECT INTO Statement
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).
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.