/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 vote32 views1 answer
Minus equivalent in my sql
SQL
0 vote40 views1 answer
How much table store postgres
SQL
5 votes46 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote43 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote44 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote40 views1 answer
Sql_inner_join
SQL
6 votes46 views2 answers
Join vs union
SQL
0 vote43 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote39 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote38 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL