REAL SQL Interview Query | Complex SQL Interview Query and Solution

Written By Thoufiq Mohammed

In this video, I solve a real SQL interview query which was shared to me by one of my subscribers.

The requirement is to write an SQL query find 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.

Click on the below button to download all the dataset, scripts and SQL queries used in this video.

Watch me solving this query here

Thoufiq Mohammed https://techtfq.com
Previous

SQL Interview Assignment Queries - Part 1 (Problem Statement)
Next

Solving SQL Query | Rows to Column in SQL