Тёмный

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

CodeEra
Подписаться 31 тыс.
Просмотров 17 тыс.
50% 1

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 RU-vid: / @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

Наука

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

 

16 июл 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 17   
@PraveenKumar-ur4jl
@PraveenKumar-ur4jl 11 месяцев назад
Very nice. Thank you
@Businessbol
@Businessbol 11 месяцев назад
Very good and simple explanation thanks 🙌
@osoriomatucurane9511
@osoriomatucurane9511 6 месяцев назад
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?
@user-ec5ii4to4l
@user-ec5ii4to4l 11 месяцев назад
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
@deyscube577
@deyscube577 7 месяцев назад
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.❤️
@Rohith_08
@Rohith_08 Месяц назад
Super ❤❤
@vitthalsabale7108
@vitthalsabale7108 5 месяцев назад
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
@developerritesh
@developerritesh 11 месяцев назад
❤❤❤
@jaymahajan3871
@jaymahajan3871 11 месяцев назад
Good 👌😊😊👍
@_badboikiller_
@_badboikiller_ 8 месяцев назад
Best video for sub query
@anupamaindapure6941
@anupamaindapure6941 2 месяца назад
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??
@VIBHAV-SOMVANSI
@VIBHAV-SOMVANSI 2 месяца назад
These sql contents are not enough for data engineer. Learn Pl/sql as well.
@kritikarya3204
@kritikarya3204 9 месяцев назад
Hey, you are really doing a noval job sharing your experties but i've a suggestion about your "guys count". Lol
@sarthakarora5469
@sarthakarora5469 4 месяца назад
"so guys"
@tracyojila
@tracyojila Месяц назад
Please how can i get this data you are working with please☺☺☺☺
@talknow2859
@talknow2859 5 дней назад
I built mine using the Create database command in her earlier videos in this series.
@yon1623
@yon1623 11 месяцев назад
does learning subqueries going to get me a girlfriend
Далее
Olive can see you 😱
01:00
Просмотров 18 млн
When to Use a Subquery in SQL
8:50
Просмотров 30 тыс.
Understanding Correlated Queries in SQL
8:13
Просмотров 138 тыс.
Неразрушаемый смартфон
1:00
Просмотров 1,8 млн
Main filter..
0:15
Просмотров 11 млн
Main filter..
0:15
Просмотров 11 млн