In Oracle Database, the UNION operator allows us to combine the results from two queries into a single result set.
Tag: operators
MariaDB MINUS Operator Explained
In MariaDB, the MINUS operator returns distinct rows from the left input query that aren’t output by the right input query.
The MINUS operator was introduced in MariaDB 10.6.1 as a synonym for the EXCEPT operator for the purposes of compatibility with Oracle. Therefore, we can use MINUS and EXCEPT interchangeably (in MariaDB 10.6.1 and later).
MariaDB UNION Operator Explained
In MariaDB, the UNION operator combines the results from multiple SELECT statements into a single result set.
MariaDB INTERSECT Operator Explained
In MariaDB, the INTERSECT operator intersects two queries and returns only those rows that are returned in both queries.
It returns all rows from the left SELECT result set that are also present in the right SELECT result set.
MariaDB EXCEPT Operator Explained
In MariaDB, the EXCEPT operator returns rows from the left input query that aren’t output by the right input query.
Another way of putting it is that it returns all rows from the left SELECT result set except rows that are in right SELECT result set.
How to Enable the Pipe Concatenation Operator in MySQL
MySQL supports the use of the pipe concatenation operator (||) for concatenating its operands. However, you need to enable it first.
MongoDB Aggregation Operators for Returning Date Parts
This article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
Continue readingMongoDB $round vs $trunc: What’s the Difference?
MongoDB’s aggregation pipeline framework includes a $round operator and a $trunc operator. These operators perform similar, but different tasks.
$strLenBytes vs $strLenCP in MongoDB: What’s the Difference?
MongoDB includes the $strLenBytes and $strLenCP operators in its aggregation pipeline framework. These operators do a similar but slightly different thing. In some cases, both will return exactly the same result, while in other cases the results will differ.
Here’s a quick overview of the difference between these two operators.
Continue reading2 Ways to Get a Document’s Size in MongoDB
If you need to return the size of a document in MongoDB, you can use the following:
- The
$bsonSizeaggregation pipeline operator - The
Object.bsonSize()method
Below are examples of each approach.
Continue reading