Know the Difference Between UNION and UNION ALL▶
A classic entry level interview question for developers and DBAs is "what is the difference between UNION and UNION ALL".
UNION ALL concatenate the results of one or more queries. UNION does the same, but it also eliminates duplicate rows:
https://hakibenita.com/sql-dos-and-donts