REAL SQL Interview Question | Complex SQL Interview Query and Solution

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 [email protected]

All the scripts, dataset and sql query can be downloaded for free from my blog or from my discord channel. Links below:
Discord channel:

Recursive SQL Queries Tutorial:

My recommended SQL Course:
My recommended SQL practice platform:

If you liked the video then do consider subscribing and giving me a like on the video.

Thank you,
Be the first to comment