SQL Tutorial #13 - SQL EXISTS and NOT EXISTS Operator

preview_player
Показать описание
In this SQL Tutorial, we will learn about SQL Exists and Not Exists Operators. EXISTS operator is used to test the existence of any record on SUBQUERY, if the SUBQUERY returns TRUE then the main query is evaluated.

🌟 Please hit LIKE ❤️, SHARE, and SUBSCRIBE for more AMAZING
courses:

🌟 TEST AUTOMATION COURSES 🌟

🌟 MANUAL TESTING AND ISTQB COURSES 🌟

🌟 SOFTWARE TESTING MOCK INTERVIEWS 🌟

🌟 SOFTWARE TESTING INTERVIEW QUESTIONS AND ANSWERS 🌟

🌟 RESUME AND CAREER TIPS 🌟

🌟 API TESTING COURSES 🌟

🌟 PROGRAMMING COURSES 🌟

🌟 TEST MANAGEMENT TOOLS 🌟

🌟 AGILE TESTING TOOLS 🌟

🌟 ATLASSIAN JIRA COURSES 🌟

🌟 AGILE PROJECT MANAGEMENT COURSES 🌟

🌟 AGILE BASICS COURSE 🌟

🌟 FOLLOW US ON TWITTER 🌟

🌟 LIKE US ON FACEBOOK 🌟

🌟 OUR TUTORIAL WEBSITES 🌟

🌟 GET MY TRAININGS ON UDEMY 🌟

✨ Tags ✨
sql exists and not exists operator,sql exists,sql not exists,where exists and not exists in sql?,not exists,sql tutorial,exists and not exists in sql,sql tutorial for beginners,what is if not exists in sql?,sql tutorial advanced,software testing mentor sql,sql course,sql tutorial youtube,exists operator in sql,not exists operator in sql

✨ Hashtags ✨
#SqlTutorial #SQL #SqlCourse #SqlBaiscs #MySQL #MySQLTutorial #LearnSql #RcvAcademy #SoftwareTestingMentor

🌟 Join this channel to support my work 🌟
  1. Software Testing Mentor
  2. sql exists and not exists operator
  3. sql exists
  4. sql not exists
  5. where exists and not exists in sql?
  6. not exists
Рекомендации по теме
SQL Tutorial #13 0:09:42

SQL Tutorial #13 - SQL EXISTS and NOT EXISTS Operator

SQL-Grundlagen in 13 0:13:27

SQL-Grundlagen in 13 Minuten: Der schnelle Einstieg

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

SQL Tutorial 13: 0:13:27

SQL Tutorial 13: TCL Commands | Commit | Rollback

More Basic Queries 0:06:18

More Basic Queries | SQL | Tutorial 13

Datenbanken und SQL 0:13:54

Datenbanken und SQL #13 - Mathematische Operatoren

SQL Tutorial für 0:51:03

SQL Tutorial für Anfänger | Grundkurs Deutsch

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

MS SQL I 0:01:30

MS SQL I Self Joins I #sqlschool #sql #onlineclasses #channel #job

SQL Server Programming 0:27:41

SQL Server Programming Part 13 - Dynamic SQL

SQL Tutorial Deutsch 3:12:35

SQL Tutorial Deutsch | Komplettkurs für Anfänger

SQL Tutorial - 4:20:39

SQL Tutorial - Full Database Course for Beginners

SQL Tutorial von 1:26:05

SQL Tutorial von W3 School (komplett auf Deutsch erklärt)

SQL Tutorial - 0:07:00

SQL Tutorial - 13: Inserting Data Into a Table From Another Table

SQL Basics for 0:27:51

SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka

SQL Tutorial 13 0:10:03

SQL Tutorial 13 Introduction to JOIN, cartesian product

SQL Bootcamp: 50 1:23:29

SQL Bootcamp: 50 SQL Queries and a Sample Dataset - SQL Tutorial for Beginners

SQL ORDER BY 0:09:33

SQL ORDER BY - Sort your Results - SQL Tutorial #13

SQL Full Course 4:07:51

SQL Full Course | SQL Tutorial For Beginners | Learn SQL (Structured Query Language) | Edureka

SQL Basics Tutorial 1:10:21

SQL Basics Tutorial for Beginners (Practice SQL Queries)

Learn SQL In 0:56:24

Learn SQL In 60 Minutes

Oracle SQL Tutorial 0:05:55

Oracle SQL Tutorial 13 - How to Add Column Constraints (Attributes)

SQL Tutorial Italiano 0:05:21

SQL Tutorial Italiano 13 - Seleziona senza duplicati con DISTINCT

Advanced or intelligent 0:12:01

Advanced or intelligent joins in sql server - Part 13

Комментарии
Автор

Hello, sir. In the first case (4:15) it really works as a true/false condition. No matter what is in the subquery, if it is true, then the main query is executed, and it returns all values from the table. While in the second case (6:46), the result of the main query is limited by the values that are returned by the subquery. Why is that? Please help me understand.

eugenesumanov
Автор

really helpful, clean explain and easy to understand!! thank you sir❤

hirunathulhid
Автор

Can I have the sample database which you are using here in the example?

PAVANKUMAR
Автор

Amazing tutorial thank you so much it was helpful

anwar
Автор

Thanks you sir i can easily understand please do more vedioes

sathoshreddy
Автор

Thanks Sir. You have made it really lucid.

dev
Автор

Could you please share with us the used database?

triguieya
Автор

If I execute the last example subquery seperately we are not getting any values but with WHERE EXISTS we are getting values. Can you please Explain?

Raj_KrishnaOfficial
Автор

thank you so much. After 2 minutes of video I understood everything

kodiq
Автор

Really well explained sir...thank you🎉

Satya_ganta
Автор

very informative thanks explained greatly

onestopdata
Автор

Hi sir,
The explanation overall is good.
But one doubt that I am not able to figure out yet, in which video did you create the Orders table and how is a primary column of table Employees linked with that of orders?

chaitanayasethi
Автор

do you use EXISTS only in a subquery or there are other use cases? thanks

nwosaelobike
Автор

Haan sir, kr diya dislike and report.
One of the worst explanation I have seen on the topic. You just read the definition and did not show the step-by-step execution. Lean to teach.

akshaychilwal