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: operators
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 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 reading12 Commonly Used SQL Operators
In SQL, an operator is a special character or keyword specifying an action that is performed on one or more expressions.
SQL operators are an integral part of SQL, and they enable us to write queries that return relevant results.
In this article, I present 12 of the most commonly used SQL operators when writing SQL queries.
Continue readingList of SQL Server Comparison Operators
Below is a list of T-SQL comparison operators that you can use in SQL Server.
Continue readingWhat is a Comparison Operator?
Comparison operators are an important part of most programming languages.
Comparison operators are used to compare two expressions. The result is either true or false. It could also be unknown. This could also be represented by either 1, 0, or NULL, depending on the language. These are typically known as “Boolean expressions”.
When used with databases, comparison operators can be used inside your SQL queries to filter data to a certain criteria.
Continue readingHow to Test for Overlapping Dates in PostgreSQL
In PostgreSQL, you can use the OVERLAPS operator to test for overlapping time periods.
The function returns true when two time periods (defined by their endpoints) overlap, and false when they do not overlap.
Continue reading2 Ways to Insert a New Line into a String in SQLite
This article presents two ways to insert a new line character into a string in SQLite.
This means you can have some text on one line, more text on another line, etc, rather than it being one long line.
Continue readingHow to Concatenate Strings in SQLite
SQLite doesn’t have a concat() function like many other database management systems, such as SQL Server’s concat() and MySQL’s concat().
However, that doesn’t mean you can’t concatenate two strings in SQLite.
SQLite has a concatenation operator (||) that you can use to concatenate two strings.