/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

3 votes161 views1 answer
System.debug apex
SQL
0 vote231 views1 answer
Data types mysql vs postgresql
SQL
0 vote207 views1 answer
How to use group_concat in sql server
SQL
0 vote206 views1 answer
Check if string is a number sql
SQL
3 votes293 views2 answers
Savepoint in sql
SQL
0 vote272 views1 answer
Regex mongoose
SQL
0 vote200 views1 answer
Sql server check whether column has same equal values
SQL
3 votes208 views2 answers
Get current year sql
SQL
25 votes246 views3 answers
Mysql command show tables
SQL
0 vote202 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL