SQL | NOT IN Vs NOT EXISTS (Which one to use?)

In this tutorial, we discuss the differences between NOT IN and NOT EXISTS.
How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Beginners to Python Programming
skillshare.eqcm.net/GjMakm
Data Science and Business Analytics with Python
skillshare.eqcm.net/JrM1Aq
IBM Data Science Professional Certificate
imp.i384100.net/LPQvg3
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Python for Everybody Specialization
imp.i384100.net/DVz7Aj
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Coursera Plus - Data Science Career Skills
imp.i384100.net/c/3299742/132...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - [e-mail]

[@phdjdoug4899]

This is the best video explanation I've come across so far that helps me understand not only the difference between NOT IN and NOT EXISTS, but also EXISTS more broadly. Thank you!

[@LearnatKnowstar]

Glad it was helpful!

[@catherine__s490]

Thank you, this was really helpful.

[@prashanth1011]

Awesome explanation madam, really appriciate your videos... I was banging my head why (NOT IN) operator is not woring as expected.. now after watching your video I know why.

[@LearnatKnowstar]

Glad it was helpful.

[@florincopaci6821]

Thank you for another usefull video.
I have a question - there is any difference when we make a inner join comparing with a join on exists not where having a 1 to many relationship?
Thank you

[@blse2000]

Amazing, Thank you.

[@reachrishav]

Interesting concept of null comparison in SQL. Thank you!

[@LearnatKnowstar]

Thank you

[@hv0032113]

Very informative

[@shekhark1139]

This video is very handy, corelated subquery and where conditions.

[@LearnatKnowstar]

Thank You!

[@NB20079]

Hi, how to fix this. After creating a table, I can't see where the table is?Before I had the success of creating a table but now i can't see the table after creating the table, Thank you

[@rk-ej9ep]

Nice explanation...👍

[@LearnatKnowstar]

Thank you

[@manjutharak]

What is difference between IN Operator and EXISTS Operator ?Which is Faster? can you make it video on this

[@SurajitMetya]

please provide the create and insert table scripts this will help everyone

[@filipzivkovic4866]

-- dbo.Employee table
create table dbo.TblEmployee
(
EmpID INT not null PRIMARY KEY,
DeptID INT not null,
SubDeptID NCHAR (10)
)
-- Inserted values
INSERT into dbo.TblEmployee (EmpID, DeptID, SubDeptID)
VALUES
(1001,1,'A'),
(1002,2,'X'),
(1003,3,'A'),
(1004,4,'A'),
(1005,5,'A')
-- dbo.TblDept
create table dbo.TblDept
(
DeptID INT not null IDENTITY(1,1) PRIMARY KEY,
SubDeptID NCHAR(10) not null
)
-- Inserted values
insert into dbo.TblDept (SubDeptID)
VALUES
('A'),
('A'),
('B'),
('A')

[@filipzivkovic4866]

My bad, I forgot to add the NULL in the TblDept table

[@Mrroy08657]

@@filipzivkovic4866
Hi bro plz tell : where is less Work load , less work Pressure & less Working Hrs. - as a Data Analyst or as Machine learning Engineer or as a Data Scientists ?

[@SurajitMetya]

It Should be "............WHERE DEPTID NOT EXISTS............" . can you elaborate more............