Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

Oracle: Anti Join

Profile picture for user akshita.goel
Written by akshita.goel on 11/17/2021 - 05:02

Anti Join in Oracle is a special kind of join that makes queries run faster. The Join helps to return those values that are only present in Table1. Any values of Table2 that are present in Table1, get filtered out when we apply Anti Join between both the tables. Anti Join is performed by using the NOT IN Clause.

Syntax

Select Column from Table1 
where Column 
NOT IN ( Select Column from Table2);

ANTI JOIN

Example

We have two tables Stu and marks table. Refer to the values in both the table below:

Stu table is as follows:
ANTI JOIN

marks Table is as follows:
ANTI JOIN

Now if we want only those values in Stu table and not in the marks table, we can use anti Join as follows:

--Anti Join
select * from Stu
where 
Roll_no NOT IN (select Roll_no from marks );

Output

ANTI JOIN

NOTE: Only those values are displayed as an output that was present in Stu and not in marks.

Related Content
Oracle Tutorial
Oracle: Difference between Natural join and Inner Join
Oracle: Cross Join
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use