New: Intelligent Flashcards spaced-repetition decks for every topic, built to make things actually stick.
What does the SQL UNION operator do to duplicate rows that appear in both result sets?
UNION
Returns only the rows that appear in both queries
Keeps every row from both queries, including duplicates
Eliminates them, returning each distinct row only once