In PostgreSQL, the INTERSECT operator combines two queries, but returns only those rows that are returned in both queries.
Tag: operators
How EXCEPT Works in PostgreSQL
In PostgreSQL, the EXCEPT operator returns rows that are returned by the left input query that aren’t returned by the right input query. This can also be referred to as the difference between two queries.
Oracle UNION Operator Explained
In Oracle Database, the UNION operator allows us to combine the results from two queries into a single result set.
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.