SQL Interview Question- Parent Child Relationship

preview_player
Показать описание
SQL Query to print child, father, and mother from relation and people table

Tables:

relation table
cid pid
101 202
566 322
875 345

people table

id name gender
101 Riya F
566 Aman M
202 Rakesh M
875 lucky M
202 Reena F
322 Raina F
345 Rohit M
322 Mohit M
345 Meena F

Output :
Child Mother Father
Riya Reena Rakesh
Aman Raina Mohit
Lucky Meena Rohith

Query :

Do Like, Comment & Subscribe :)
Got a question on the topic? Please share it in the comment section below and we will answer it for you.

#sqlinterview #sqlinterviewquestionsandanswers #sqlinterviewquestions #sql #mysql #parentchildrelationship #parent #child #relationship #interview #interviewquestions #interviewpreparation #interviewpreperationcourse #SQL #RDBMS #database #bigdata #dataengineering
  1. Code it
  2. code it
  3. interview
  4. coding interview
  5. java program to
  6. sql interview
Рекомендации по теме
SQL Interview Question- 0:13:27

SQL Interview Question- Parent Child Relationship

Solving an SQL 0:13:47

Solving an SQL Interview Problem | Find Child - Parent - Grandparent Hierarchy using SQL

Multilevel parent child 0:06:31

Multilevel parent child relationship | sql server interview question and answer Part 52

REAL SQL Interview 0:22:09

REAL SQL Interview Problem | Hierarchical data in SQL

In a parent 0:02:43

In a parent child relationship which constructor fires first ?

SQL real time 0:01:00

SQL real time scenario interview questions and answers Find child table with Parent table #sqlserver

SQL : SQL 0:01:26

SQL : SQL Query to find Parent-Child Child-Parent relationships?

Subscriber Comments Reply 0:11:31

Subscriber Comments Reply Video 33 | Query to find parent having one male child and one female child

SQL Interview Question 0:17:26

SQL Interview Question | How to find all levels of Employee Manager Hierarchy | Recursion

SQL Problem Solving: 0:05:49

SQL Problem Solving: Deriving Grandparent Using Self Join | Step-by-Step Tutorial

SQL : Flatten 0:01:30

SQL : Flatten parent child relationship in SQL Server

Top 65 SQL 0:53:44

Top 65 SQL Interview Questions and Answers | SQL Interview Preparation | SQL Training | Edureka

Data Analyst SQL 0:22:03

Data Analyst SQL Interview Question | Normal vs Mentos vs Mentos PRO Life

Part 2 0:10:14

Part 2 SQL query to get organization hierarchy

Top 60 SQL 0:28:02

Top 60 SQL Interview Questions 🔥For WINNERS!

SSIS Interview Questions 0:03:31

SSIS Interview Questions Answers | How to Call SSIS Packge from SQL Server in Parent Package

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

Top 65 SQL 0:55:33

Top 65 SQL Interview Question and Answers | SQL Training | Edureka Rewind - 6

SQL : Query 0:01:07

SQL : Query parents and children in self-referencing table

Oracle PL SQL 0:09:38

Oracle PL SQL interview question | oracle pragma autonomous transaction

SQL : SQL 0:01:27

SQL : SQL Query for Parent Child Relationship

SQL Server Hierarchical 0:35:26

SQL Server Hierarchical Queries - CTE vs JOIN (Parent Child , Category Subcategory)

C# Constructor Execution 0:06:46

C# Constructor Execution order Parent Child | C# Interview Questions | Csharp Interview Question

🔥 SQL Joins 0:23:23

🔥 SQL Joins Interview Questions and Answers For 2024 | Interview SQL Query On Joins | Simplilearn