How is UNION different from UNION ALL ?
3 Likes
In SQL, UNION ALL retains all duplicate rows from tables in the final output, while UNION removes duplicate rows from the final output.
UNION ALL
UNION
Answered By
How is equi-join different from non-equi-join?
What set operations can you perform through SQL ?
How is INTERSECT different from MINUS operation ?
A …………… is a query that retrieves rows from more than one table or view: