/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 vote247 views1 answer
Insert or update cassandra
SQL
0 vote278 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote260 views1 answer
Postgresql delete multiple rows
SQL
150 votes473 views10 answers
Grepper
SQL
0 vote269 views1 answer
Executescalar in sql server
SQL
1 vote273 views1 answer
Mysql select all and rename one
SQL
0 vote260 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote314 views1 answer
Mysql concatenate select results
SQL
0 vote268 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote270 views2 answers
Oracle create tablespace autoextend
SQL