How to find common rows in SQL?

Which SQL statement should you use to find rows that are present in both data sets?

UNION ALL

EXCEPT

JOIN

INTERSECT

MINUS

UNION

CONCAT

Mark all correct answers and click the "Check!" button

Tutorial Get hint

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $54.98 Goal: $100.00

Progress: 55%

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.

Practice

Lessons

Playground

Test

How to find common rows in SQL?

Login

Register

How to find common rows in SQL?