No video :(

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

Подписаться 44 тыс.

Просмотров 11 тыс.

50% 1

In this tutorial, we discuss the differences between NOT IN and NOT EXISTS.
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate
imp.i384100.ne...
Practice SQL Queries on Your Browser through Interactive Courses -
learnsql.com/?...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Blog - know-star.blogs...
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

Опубликовано:

21 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@phdjdoug4899 11 месяцев назад

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 11 месяцев назад

Glad it was helpful!

@prashanth1011 4 месяца назад

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 3 месяца назад

Glad it was helpful.

@reachrishav Год назад

Interesting concept of null comparison in SQL. Thank you!

@LearnatKnowstar Год назад

Thank you

@shekhark1139 Год назад

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

@LearnatKnowstar 11 месяцев назад

Thank You!

@blse2000 3 месяца назад

Amazing, Thank you.

@catherine__s490 Год назад

Thank you, this was really 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

@manjutharak Год назад

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

@hv0032113 Год назад

Very informative

@rk-ej9ep Год назад

Nice explanation...👍

@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

@SurajitMetya Год назад

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

@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 ?