3 ms·
You'd also need a LIMIT or a TOP, and you might need a subquery for that depending on your SQL of choice.
by hobs 3y ago
You'd also need a LIMIT or a TOP, and you might need a subquery for that depending on your SQL of choice.
- hans_castorp 3y agoThe 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
- deleted 3y ago[deleted]