MySQL + SQL · Lesson 76

INTERSECT and EXCEPT Alternatives in MySQL

Set Operations

INTERSECT (common rows) and EXCEPT (rows in first not second) are set operations. Older MySQL lacks them, so we use IN / NOT IN or JOINs.

Workarounds

-- INTERSECT: students who are also toppers
SELECT roll_no FROM students
WHERE roll_no IN (SELECT roll_no FROM toppers);

-- EXCEPT: students who are NOT toppers
SELECT roll_no FROM students
WHERE roll_no NOT IN (SELECT roll_no FROM toppers);

Summary

  • INTERSECT = common rows; EXCEPT = in first but not second.
  • In MySQL, simulate with IN / NOT IN subqueries.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.