I have a SQLite table representing a music library called
it looks something like this (there are many more columns, I am simplifying)
title | album | artist
a song | an album| an artist
I am trying to select a list of all albums. Now, on first thought,
SELECT DISTINCT album FROM songs
should work. HOWEVER, this fails if, for example, 2 artists have an album with the same title. Really what I want, is to go through each artist and select 1 of each album therein.
How might I do this?