UNION vs UNION ALL
Learn UNION vs UNION ALL (Set Operations, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction UNION stacks the rows of two or more SELECTs into one result and removes duplicate rows . UNION ALL stacks them and keeps every row, duplicates included. Both need the same number of columns, matched by position.