Sql Commands, Union, Intersect, And Minus Write A Paper Of 500

SQL CommandsNameInstitutional affiliateSQL Commands UNION, INTERSECT, and MINUSSQL is a query language developed in the 1970s by IBM’s Donald D. Chamberlin and Raymond F. Boyce. The acronym stands for the Structured Query Language. It is used to communicate with relational databases. The language is made of a data definition language, data manipulation language, and Data Control Language. This enables the language to perform major database functions such as inserting, performing database queries, change the content of the database and eliminate a record, schema creation and modification, and regulate who is able access certain data from the database (Fehily, 2005).. It is therefore commonly used in relational database management systems (RDBMS) applications. The RDBMS use SQL commands or operators to access the database, and to manipulate its content. This document will discuss the three commonly used SQL commands; UNION, INTERSECT, and MINUS. UNIONThe UNION operator is used to bring together the results of two or more queries, where the column data types in the different queries match (Oracle, 2016). The syntax of the UNION command is as follows:SELECT column-names FROM table-name UNIONSELECT column-names FROM table-nameFor example; a university database