How is UNION different from UNION ALL ?
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