An INTERSECT operation retrieves the matching set of distinct values (not rows) from two columns. The INTERSECT ALL returns the…
A UNION operation combines two sets of columns and removes duplicates. The UNION ALL expression does the same but does…
COALESCE DB2 function is used to handle the NULL values that might be present in the data or a list…