36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL

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!

📚 SQL Practice Questions -

🔶Create Employee Table

🔶Insert Data into Employee Table

Connect with us on different platforms

SQL BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL

📌35-SELF JOIN in SQL |JOIN Tutorial

📌34 - CROSS JOIN in SQL | Cartesian Product

📌33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN

📌32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join

📌31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN

📌30-Introduction to Joins & its types | Need of Joins with example

📌29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus

📌28-Conversion Functions in SQL| CAST VS CONVERT | STR_TO_DATE

📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...

📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()

📌25-String Functions in SQL

📌24-Difference Between WHERE and HAVING CLAUSE in SQL

📌23-HAVING CLAUSE in SQL

📌22 -GROUP BY Clause in SQL

📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN

📌20 -TOP Clause in SQL | FETCH FIRST Clause

📌19- LIMIT and OFFSET in SQL

📌18- ORDER BY Clause in SQL

📌15 - SQL BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL

⭐Part 1:Top 9 SQL queries for interview -

⭐Part 2:Top 9 SQL queries for interview -

⭐Top SQL Interview Question

⭐Interview SQL Query On Joins

⭐DBMS vs RDBMS

⭐SQL Query To Swap Value Of Male and Female In Single Statement

#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

[deyscube]

I was watching a lot of videos on the same topic..all doubts cleared here only.
Reason why best: with example of each subqueries like (=, <, >=/in, not in, any/examples on correlated)

This points helped me to clear which bigger channels could not do.
Fond of you.❤️

[GaurishankarPatle-wf]

Please make a video on cte, view, local &global table, stocked procedures, you explaination verry good. It will help to clear all doubts. Thanks for sharing your knowledge with us .thanks

[osoriomatucurane]

Awesome tutorial on sql subqueries. Concise, crystal clear. The scalar and multiple rows subqueries are kind of chaining operation in R and Python. The output from previous operation, as an intermediate step, is called and used in the next operation. Correct?

[vitthalsabale]

Hello Saloni,
Thank you for sharing your SQL session, it's very help full for beginner's. In this session you have mentioned ORDER BY command can't be used in a Subquery, So please check below query and suggest me know, Is this Subquery or not ? because we are using ORDER BY clause under this query.

SELECT TOP 1 SALARY FROM (SELECT DISTINCT TOP 3 SALARY FROM EMPLOYEE ORDER BY SALARY DESC) EMPLOYEE ORDER BY SALARY ASC;

I hope you will reply on this comment to clear my doubts

[anupamaindapure]

hello mam, where did you learn this all content was so informative. can this sql can enough for data analyst or data engineer role?can you suggest please??

[Businessbol]

Very good and simple explanation thanks 🙌

[kritikarya]

Hey, you are really doing a noval job sharing your experties but i've a suggestion about your "guys count". Lol

[tracyojila]

Please how can i get this data you are working with please☺☺☺☺

[yon]

does learning subqueries going to get me a girlfriend