Union and Union All in SQL|SQL tutorials for beginners |SQL interview question and answer.
Union and Union All in SQL
SQL tutorials for beginners.
SQL interview question and answer.
Union and union all which on more faster.
Performance of union and union All.
------------------Union----------------------
SELECT EmpName as UnionRecord FROM Emp
UNION
SELECT EmpName as UnionRecord FROM EMPBIRTHINFO
------Union All------------------------------------------
SELECT EmpName as UnionAllRecored FROM Emp
UNION All
SELECT EmpName as UnionAllRecored FROM EMPBIRTHINFO
