Video Discription |
SQL Full Course Playlist 👇
https://www.youtube.com/playlist?list=PLdOKnrf8EcP17p05q13WXbHO5Z_JfXNpw
Like, Share & Subscribe :)
⭐ Subscribe for more data science related tutorials: https://bit.ly/3Fc7Gc6
⭐ Download PDF: https://rb.gy/k3htx
Query to create Employee table:
CREATE TABLE employees (
emp_id serial PRIMARY KEY,
emp_name VARCHAR NOT NULL,
manager_id INT )
INSERT INTO employees (
emp_id, emp_name, manager_id)
VALUES
(1, 'Madhav', NULL),
(2, 'Sam', 1),
(3, 'Tom', 2),
(4, 'Arjun', 6),
(5, 'Shiva', 4),
(6, 'Keshav', 1),
(7, 'Damodar', 5);
📢 GitHub link (all files): https://bit.ly/3Y7SRPr 📢
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐CHAPTERS⭐
00:00 Intro
00:16 What is Recursive CTE
01:21 Recursive CTE Syntax
02:36 Example 1
08:35 Example 2
➖➖➖➖➖➖➖➖➖➖➖➖➖
👉Also Watch
👉Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1
https://www.youtube.com/watch?v=yH1zCq-iaeU
👉SQL CTE (Common Table Expression) | SQL Tutorial In Hindi 16
https://youtu.be/WHBH0yz35_8
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
👉Instagram: https://www.instagram.com/rishabhnmishra/
👉LinkedIn: https://www.linkedin.com/in/rishabhnmishra/
👉Twitter: https://twitter.com/rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Related video:
🔖 Data Analyst Roadmap 2023: https://www.youtube.com/watch?v=p9vjhj7_A4o
🔖 Most Asked SQL Questions for Job interview: https://www.youtube.com/watch?v=AZzTHWF7tEc
🔖 What Does a Data Analyst Actually Do?: https://www.youtube.com/watch?v=ZFZc8-PugcA
🔖 5 Minimum Skills to Get a Data Analyst Job: https://www.youtube.com/watch?v=JJdD_oM1CmQ
🔖 Business Analyst Vs Data Analyst: https://www.youtube.com/watch?v=9XmD2o5Slb8
🔖 How I Learned Data Science Skills & Switched Career : https://www.youtube.com/watch?v=qvKspeuyBfQ
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
Related keywords:
recursive sql queries, recursive CTE , sql recursion, recursive sql, how does a recursive CTE work, how recursion works, sql, server, interview questions, answers, freshers, experienced, SQL, sql tutorial, recursive sql queries, sql recursion, recursive sql, Learn to write SQL Queries, rishabh mishra sql, sql query writing, recursive cte, practice sql queries, practice complex sql queries, complex sql queries, learn sql, recursive sql queries, recursive CTE , sql recursion, recursive sql, common table expression, recursive sql query in Oracle, recursive sql query in MySQL, sql by rishabh mishra,recursive sql query in Microsoft SQL Server, recursive sql query in PostgreSQL, recursive cte, sql server tutorial, cte reference itself, recursive cte ordering hierarchical result, recursive cte with level [Rp3EcF9nx6U] |