Set operators are the SQL operators that deal with combining, in different ways, different result sets. Say you have two different SELECT s that you want to combine into a single result set, the set operators come into play. MariaDB has been supporting the UNION  and UNION ALL set operators for a long time, and these are by far the most common set operators.

But we are getting ahead of ourselves here, let me first explain the set operators that we have and how they work. If you want to give this a try, you can use your existing deployment of MariaDB Server, or try this out in a MariaDB SkySQL cloud database.

#database #sql #oracle #mariadb #data migration #set operators