SQL-UnionClause-Page15
πConcatenating Data
πUnion Clause
The Union clause merges the output of two or more queries into a single set of rows and columns.
Below query will get the combined list of customers whose customer no starts with "C" and "E".
πIntersect Clause
The output of an intersect clause will include only those rows that are common to both the queries.
Comments
Post a Comment