How is UNION different from UNION ALL ?
2 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
1 Like
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: