By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
person_id | name |
---|---|
1 | tom |
2 | dick |
3 | harry |
4 | susan |
5 | mary |
6 | jill |
Records: 8 Duplicates: 0 Warnings: 0
friend1 | friend2 |
---|---|
2 | 1 |
1 | 2 |
3 | 2 |
2 | 3 |
4 | 3 |
3 | 4 |
6 | 5 |
5 | 6 |
person_id | name | person_id | name |
---|---|---|---|
1 | tom | 2 | dick |
1 | tom | 3 | harry |
1 | tom | 4 | susan |
2 | dick | 1 | tom |
2 | dick | 3 | harry |
2 | dick | 4 | susan |
3 | harry | 1 | tom |
3 | harry | 2 | dick |
3 | harry | 4 | susan |
4 | susan | 1 | tom |
4 | susan | 2 | dick |
4 | susan | 3 | harry |
5 | mary | 6 | jill |
6 | jill | 5 | mary |