The equals operator (=
) is probably the most commonly used operator in SQL. It compares the equality of two expressions. Even if you’ve only just begun your SQL journey, you’ll probably know this operator.
Tag: create query
SQL NOT Operator for Beginners
In SQL, the NOT
operator negates a Boolean input (it reverses the value of any Boolean expression). Therefore it returns TRUE
when the expression is FALSE
.
SQL BETWEEN Operator for Beginners
In SQL, the BETWEEN
operator allows you to check for values that are within a given range.
The BETWEEN
operator specifies a range to test, and it returns TRUE
when the operand is within the range of comparisons.
SQL AND Operator for Beginners
In SQL, the AND
operator allows you to check for multiple conditions when filtering your queries.
The AND
operator combines two Boolean expressions and returns TRUE
when both expressions are TRUE
.
SQL OR Operator for Beginners
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
.
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 reading