37-Subquery Using ALL,ANY & EXISTS Operators in SQL | Example | Advance SQL | EXISTS vs IN vs JOINS

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
📚 SQL Practice Questions -
codeera.netlify.app/sql-pract...
🔶Create Employee Table
codeera.netlify.app/wp-conten...
🔶Insert Data into Employee Table
codeera.netlify.app/wp-conten...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlify.app/
✅ Subscribe us on UA-cam: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroupCodeEra
SQL BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL
• 15 - SQL BETWEEN & NOT...
📌36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video
• 36 Subquery in SQL | ...
📌35-SELF JOIN in SQL |JOIN Tutorial
• 35-SELF JOIN in SQL |J...
📌34 - CROSS JOIN in SQL | Cartesian Product
• 34-CROSS JOIN in SQL |...
📌33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN
• 33 -SQL JOINS Tutorial...
📌32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join
• 32-How to Join 3 or mo...
📌31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN
• 31-INNER JOIN & NATURA...
📌30-Introduction to Joins & its types | Need of Joins with example
• 30-Introduction to Joi...
📌29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus
• 29-SET Operators in SQ...
📌28-Conversion Functions in SQL| CAST VS CONVERT | STR_TO_DATE
• 28-Conversion Function...
📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...
• 27-Date & Time Functio...
📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()
• 26-Numeric Functions i...
📌25-String Functions in SQL
• 25-String Functions in...
📌24-Difference Between WHERE and HAVING CLAUSE in SQL
• 24-Difference Between ...
📌23-HAVING CLAUSE in SQL
• 23-HAVING CLAUSE in SQ...
📌22 -GROUP BY Clause in SQL
• 22 -GROUP BY Clause in...
📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN
• 21-Aggregate Functions...
📌20 -TOP Clause in SQL | FETCH FIRST Clause
• 20 -TOP Clause in SQL ...
📌19- LIMIT and OFFSET in SQL
• 19- LIMIT and OFFSET i...
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
📌15 - SQL BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL
• 15 - SQL BETWEEN & NOT...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
#sql
#sqlcourse
#join
#sqlforbeginners
#innerjoin
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#sql
#having
#sqlhavingclause
#groupbyclause
#sqlgroupbyclause
#sqlselectcommand
#LearnCoding
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncodin
#clause
#sqlserver
#top
#sqlqueries
#join
#innerjoin
#cross
#self
#selfjoin
#subscribe
#subquery
#correlation
#SubqueryInSQL #SQLSubQueryTutorialWithExamples #WhatareSubQueriesInSQL #SQLSubQeuriesExplained #SQLTutorial #SQLTutorialForBeginners #SQLCourse #SQLTraining #SQLForBeginners #SQLCourse #SQLTraining

[@Tech.S7]

Simple very short ways.... Explained like a pro... Layman can also understand..... Good teaching 🙏

[@AnandMishra-ou3tv]

Very helpful videos thnx ❤

[@attacker21]

Really helpful thanks a lot

[@jamesopoku8049]

Nice tutorial, keep it up, I really like your videos 👋👋👋

[@nasimahmed6832]

great work

[@aryabhatt5833]

Thank you ma'am.

[@sivadurga9204]

Very Precise explanation 👏

[@jaymahajan3871]

Good 👌😊👍😊

[@maheshmenta6078]

simple explanation mam tq

[@CodeEra2020]

Thanks for watching

[@user-qe7pr6rx7k]

Nice explanation madam

[@CodeEra2020]

Thanks for watching

[@prajuyaragorla8161]

how to find deptname =it second highest sal ..like out put empno dname sal deptno

[@nandhunavrath]

The last query in this video: using 'IN' operator, shouldn't the subquery be - select customers.name
ie.,: (select customers.name from orders where orders.customer_id = customers.id)
as orders table doesn't have name column?

[@SiamData]

for the first example couldn't we just use in operator?

[@sabari752]

100th like is mine