Comment by hobs
2 years ago
You'd also need a LIMIT or a TOP, and you might need a subquery for that depending on your SQL of choice.
2 years ago
You'd also need a LIMIT or a TOP, and you might need a subquery for that depending on your SQL of choice.
The question was "the longest track per album", so I'd expect one row per album as the result (which is what my query does). But adding a LIMIT would not do that.
It might be that the question was "the longest track across all albums" which indeed would require a LIMIT