36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL
Вставка
- Опубліковано 16 лип 2023
- 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...
📌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 - Наука та технологія
Very nice. Thank you
Very good and simple explanation thanks 🙌
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
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?
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.❤️
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
Very well explained ma'am
Super ❤❤
❤❤❤
Best video for sub query
Good 👌😊😊👍
Hey, you are really doing a noval job sharing your experties but i've a suggestion about your "guys count". Lol
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??
These sql contents are not enough for data engineer. Learn Pl/sql as well.
"so guys"
Hello madam
Please how can i get this data you are working with please☺☺☺☺
I built mine using the Create database command in her earlier videos in this series.
does learning subqueries going to get me a girlfriend