Skip
Arish's avatar

200. SELF CROSS JOIN

Cartesian Self Join

All pairs from same table.

sql
1SELECT a.name AS student1, b.name AS student2
2FROM students a, students b
3WHERE a.id < b.id;