In SQL, the OR operator allows you to use alternative conditions when filtering your queries.
The OR operator combines two conditions, and returns TRUE when either of the conditions is TRUE.
Tag: create query
SQL EXISTS Operator for Beginners
In SQL, the EXISTS operator specifies a subquery to test for the existence of rows. It returns TRUE when the subquery returns one or more rows.
A subquery is a query that is nested inside another query (or even another subquery)
This article contains some basic examples of the EXISTS operator.
SQL IN Operator for Beginners
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 readingSQL 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 Joins Tutorial
A SQL join is where you run a query that joins multiple tables.
This SQL joins tutorial presents basic examples of SQL joins, as well as an introduction to the various join types.
Continue readingBasic SQL Queries
This article contains examples of basic SQL queries that beginners can use to retrieve data from their databases.
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.