In this video, we shall look at a COMPLEX SQL Interview query which was shared to me by one of my subscribers. We shall understand the problem statement first and then try to solve it.
This complex SQL query is about finding all the family members from a given table. We need to group together members from the same family and then give a unique family id for each family.I have solved the problem using recursive sql query but of course you may have other solutions to the same problem. In case you do, then do not hesitate to share your solution in the comments below or you can email me your solution at techtfq@gmail.com
All the scripts, dataset and sql query can be downloaded for free from my blog or from my discord channel. Links below:
Blog: techtfq.com/video/real-sql-in...
Discord channel: / discord
Recursive SQL Queries Tutorial: • Recursive SQL Queries ...
My recommended SQL Course: learnsql.com/?ref=thoufiqmoha...
My recommended SQL practice platform: www.stratascratch.com/?via=te...
If you liked the video then do consider subscribing and giving me a like on the video.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq
Негізгі бет REAL SQL Interview Question | Complex SQL Interview Query and Solution
Пікірлер: 123