UNION ALL on a table with repeated values

Question

Accepted Answer

UNION ALL never removes duplicates - not within each SELECT and not across the two SELECTs. The first SELECT returns 'login' twice (both rows match), and the second SELECT also returns 'login' twice. Concatenating them gives four rows. UNION would collapse all of those into a single 'login' row.