Union operators
--Two union operators:--
--1)Union 2)Union All:
--Union:-All the unique values are displayed in the result.
--Union All:-The different values(unique or non-unique are displayed in the result).
--To use the Set operators:--
---1)Data Types must be the same for the columns mentioned in the query.
---2)The no of columns must be the same.
Union operators
Reviewed by Rupesh
on
13:02
Rating:
No comments: