/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

5 votes156 views3 answers
Db begintransaction laravel
SQL
0 vote130 views1 answer
Sql express database size limit
SQL
0 vote121 views1 answer
Mysql with
SQL
0 vote231 views1 answer
Mysql edit trigger
SQL
0 vote121 views1 answer
How many rows affected in sqllite
SQL
2 votes146 views1 answer
Query to find table size in oracle 12c
SQL
0 vote141 views2 answers
Postgresql variable in query
SQL
0 vote130 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote127 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote130 views1 answer
Sql replace id with name from another table
SQL