Learn SQL: SELF JOIN

Today, we want to tell you about SELF JOIN and when this clause can be useful.

Imagine you have a table with a list of the company's employees, and some of these employees report to each other. Your goal is to get each employee's name and the name of their respective manager. How can you do this? Here, the SELF JOIN clause comes in handy.
--
Entire educational playlist:    • Learn SQL with DBeaver  
Aliases:    • Learn SQL: Aliases  
How to download and install DBeaver Community:    • How to download and install DBeaver W...  
--
Try DBeaver PRO for free (14 days trial): https://dbeaver.com/trial/
--
Contact us:

E-mail: [email protected]
GitHub: https://www.github.com/dbeaver
LinkedIn:   / dbeaver  
Twitter:   / dbeaver_news  
Facebook:   / dbeavercorporation  
--
Subscribe to our channel to get more interesting videos about DBeaver and the database world!