35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN

Показать описание

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

📌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

⭐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

Рекомендации по теме

Комментарии

Hiiii salonii Dii happy to tell you I follow your full playlist and finally I crack the job. Thank you so much ❤

Please keep it up I want to learn more from

javajugadcode

select manager_id as "Manager", count(manager_id) as "Subordinates" from emp group by manager_id order by manager_id;

kavitha-

hii salonii garu so wonderful your teaching so I want your SQL basic to advance tutorial some theoretical content so snd any pdf mam

kasadurgaprasad

We can solve the question with group by clause.

vhsvwcs

Will you please provide practice questions answer query

maheshmahi

self join m two tables create krege to usme inner join ka use krege mem?
pls clear the doubt?

prachithakur

could you please provide the solution of last question

sagarsharma

Hii salonii please upload next topic video i am waiting to learn

ranaprathap

Hey there!
If you are good in whole sql software plz let me know !
If you are interested teach me sql and also drop ur mail or online portal so that I can join there or learn some sql in adv

oomehtl

select e.emp_name, COUNT(e.emp_id) as number_sub_orninates
from employee e join employee m
on e.emp_id=m.manager_id
group by e.emp_name, m.manager_id
having COUNT(e.emp_id)<> m.manager_id;

Can you plz let me know, wether this query works for final question you have given r not. If so, plz provide an answer for that plz

Resh_Aadil_AllaboutExperience

self join m two tables create krege to usme inner join ka use krege mem?
pls clear the doubt?

prachithakur

35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN

35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN

MySQL SELF JOINS are ... ughhh

Self Join in SQL

35. Essential SQL - Self Join | Data Analysis Essentials

Self join in sql server - Part 14

SQL Self Join Concept | Most Asked Interview Question | Employee Salary More than Manager's Sal...

MySQL: JOINS are easy (INNER, LEFT, RIGHT)

Lec-40: Self Join operation with Example | Database Management System

SQL Tutorial #35 - CROSS JOIN in SQL | SQL CROSS JOIN with Examples

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2

SQL JOINS Interview Question | What does different SQL Joins return?

SQL Joins - How to use Inner Join, Outer Join, Self Join

What is Self-Join ?

SQL Self Join | Quick Tips Ep58

SQL Server'da Self Join

Database Design 50 - Self Join

#sql interview question How to achieve Organisational hierarchy using self join from one table | DE

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1

Oracle Self Join

Data Analyst SQL Interview Question |Self-Joins Explained #dataanalysis #sql #sqlinterview

SELF JOIN - объединение таблицы с самой собой | Практика по SQL...

SQL Query To Fetch Employees Who Are Also Managers | Self Join Example | SQL Interview Question

11. Self Join Based Question (Top 20 SQL Interview Questions) |SQL Interview Series for Freshers|

SELF JOINS|PRACTICE SQL QUERIES|