How does this scenario of UNION deduping work in SQL?

Question

Closed. This question needs details or clarity. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65931515/how-does-this-scenario-of-union-deduping-work-in-sql

Answer 1

Union removes duplicate of all column combination. it wont remove duplicate using single column. so the result of the query is 2 row.