Question 150Asked in DSSSB PGT Computer Science (Technical), 11 Jul 2021What is self join in Database Management System?
- AIn a self join, a table is joined to a number
- BIn a self-join, a table is joined to itself
- CIn a selfjoin, a table is joined with a query
- DIn a self-join, two databases are joined
Show answerHide answer
Correct answer: (B) In a self-join, a table is joined to itself
Explanation
A self join joins a table to itself, usually using aliases, e.g., to pair employees with their managers in the same table.