Self join

About this topic

Join a table with itself.

Part of SQL & DBMS: 22 topics, 5 free.

More topics in this course

• What is a database? Tables, rows, columns
• SELECT and WHERE
• ORDER BY, LIMIT, DISTINCT, LIKE
• COUNT, SUM, AVG, MIN, MAX
• GROUP BY and HAVING