Question

Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically removing duplicate rows from the combined result?

Q: Answer-Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically...

UNION combines the result sets of two or more SELECT statements with compatible column structures into a single result set, automatically removing any duplicate rows. UNION ALL performs the same combination but keeps all duplicates. JOIN combines columns from related tables based on a condition, rather than stacking result sets, and INTERSECT returns only rows common to both result sets rather than combining them.