In MySQL, the VALUES statement returns a set of one or more rows as a table. Basically, it’s a table value constructor in accordance with the SQL standard, which also functions as a standalone SQL statement.
The VALUES statement was introduced in MySQL 8.0.19.
In MySQL, SHOW TABLES is an administrative statement that lists the non-TEMPORARY tables and views in a given database.
SHOW TABLES only lists the tables and views for which you have privileges.
In MySQL, the UNION clause combines the results from multiple queries into a single result set.
In MariaDB, SHOW TABLES is an administrative statement that lists the non-TEMPORARY tables, sequences and views in a given database.
In Oracle Database, the INTERSECT operator is used to create a compound query that returns the intersection of the results of the left and right SELECT statements. In other words, it combines two queries, but returns only those rows that are returned in both queries.
In Oracle Database, the MINUS operator is used to return only unique rows returned by the first query but not by the second.
In PostgreSQL, the UNION operator combines the results from multiple queries into a single result set.
In PostgreSQL, the INTERSECT operator combines two queries, but returns only those rows that are returned in both queries.
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.
In Oracle Database, the UNION operator allows us to combine the results from two queries into a single result set.