What does UNION do when combining two SELECT statements?

SQL Data Analyst Easy

SQL Data Analyst — Easy

What does UNION do when combining two SELECT statements?

Key points

  • UNION combines result sets and eliminates duplicates
  • The final result set will only have unique rows
  • UNION does not keep duplicates, unlike some other options

Ready to go further?

Start full exam Practice more questions

Related questions