Jump to content

Ericc

Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

Ericc's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Ericc
    Ericc joined the community
  2. Ericc

    Count with sub querry

    Ericc posted a topic in SQL

    I have this table "plays": artist title artist_1 title_1 artist_1 title_1 artist_1 title_2 artist_2 title_1 I want to have something like this: artist title counts artist_1 title_1 2 artist_1 title_2 1 artist_2 title_1 1 I tried some querries wih SELECT DISTINCT and and GROUP BY but did not get what i wanted. Do you have any hint for me? I guess i need a sub querry. Thank you!
×
×
  • Create New...