/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 vote319 views1 answer
Sqlite3 get data from table c
SQL
2 votes341 views2 answers
Install postgresql
SQL
5 votes334 views1 answer
Oracle list functions
SQL
1 vote375 views1 answer
Drop colum oracle 18c
SQL
2 votes354 views1 answer
Dbms transaction (psql)
SQL
11 votes347 views3 answers
Pl sql example
SQL
0 vote368 views1 answer
Doesn't have default value mysql
SQL
1 vote348 views3 answers
Sql union
SQL
0 vote308 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote321 views1 answer
Sql server express download
SQL