• Resolved tedwardo24

    (@tedwardo24)


    Im running a query on my database that has a list of my mp3’s. I want to know how many DIFFERENT albums I have (so repeats should not be counted).

    Example:
    I have 5 pink floyd albums, so in each row of my database I have each individual song from those albums, and in the ‘album’ column I have what album each song belongs to. So, I want to just fetch the 5 album names.

    How would I run a query??

    SELECT * ... FROM 'mp3s' WHERE ... ??

    Please let me know. Much appreciated!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘*tough* SQL query question’ is closed to new replies.