/SQL/How to get parent and child record in single query using sql

How to get parent and child record in single query using sql

SELECT child.Id,
       child.Name,
       child.ParentId,
       parent.Name as ParentName
FROM your_table child
JOIN your_table parent ON child.ParentId = parent.id;

Similar codes

0 vote360 views2 answers
Check mysql timezone
SQL
0 vote347 views1 answer
Order by monthly in sql
SQL
5 votes371 views1 answer
Postgres integer to serial
SQL
6 votes396 views3 answers
Rename column ORACLE
SQL
1 vote344 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote353 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote347 views1 answer
Sql auto_increment syntax
SQL
1 vote367 views4 answers
Aggregate function in sql
SQL
0 vote355 views1 answer
Sql how to display two atributes as one in sql
SQL
8 votes380 views1 answer
How to check mysql version in xampp
SQL