What does the INTERSECT operator do in SQL?

Combines all rows from two queries

Returns common rows from two queries

Excludes matching rows

Joins tables

INTERSECT returns only the rows that are common to both queries, removing duplicates.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.