In MariaDB, SHOW TABLES is an administrative statement that lists the non-TEMPORARY tables, sequences and views in a given database.
what is
Oracle MINUS Operator Explained
In Oracle Database, the MINUS operator is used to return only unique rows returned by the first query but not by the second.
How UNION Works in PostgreSQL
In PostgreSQL, the UNION operator combines the results from multiple queries into a single result set.
How INTERSECT Works in PostgreSQL
In PostgreSQL, the INTERSECT operator combines two queries, but returns only those rows that are returned in both queries.
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 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.