Jump to level 1
What type of join is the query? Select all that apply.
SELECT Song1. Title, Song2. Title
FROM Song As Song1, Song As Song2
WHERE Song1. Length > Song2. Length
Equijoin
Non-equijoin
Self-join
Cross-join
Check
How was this section?

This query showcases a self-join, as it involves the same table (Song) being joined with itself. The condition in the WHERE clause requires that one song’s length is greater than another’s, effectively creating a comparison across the same dataset.

Additionally, since the query does not employ an equality condition in the join (but rather a greater than), it also qualifies as a non-equijoin. So, while it generates results based on comparisons between two instances of the same table, it avoids the straightforward equality often seen in joins.