Which SQL keyword prevents duplicate rows when combining results from two SELECT statements?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

Which SQL keyword prevents duplicate rows when combining results from two SELECT statements?

Key points

  • UNION is used to combine the results of two SELECT statements and remove duplicates.
  • UNION ALL includes all rows, even duplicates.
  • INTERSECT ALL returns all rows that are common to both SELECT statements.
  • DISTINCT ALL is not a valid SQL keyword.

Ready to go further?

Start full exam Practice more questions

Related questions