Jump to content

Janthine

New Members
  • Posts

    7
  • Joined

  • Last visited

Janthine's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Janthine

    join rows

    The first table is an example how I worked it out..so per score there is a row now ...now I want to bring it back per ID and that worked with what you explained SELECT id, SUM(year1), SUM(year2), ... FROM table GROUP BY id and when I write SUM(year1)>0 year1 it gives the scores per ID in each column. Now I like to see the different scores in one row but I guess it's won't work out
  2. Janthine

    join rows

    if ID 1 has in year_1 a score of B and C I would like to see in column year_1: B,C
  3. Janthine

    join rows

    No it is random, A B C can be placed anywhere
  4. Janthine

    join rows

    I think it works by command group_concat ?
  5. Janthine

    join rows

    Oh I want one row per ID
  6. Janthine

    join rows

    Hello, thanks Vinny, yes by SUM I get the score counted up. The second one, I thought the Bs were merged into one row.
  7. Janthine

    join rows

    Hello, hope someone can help me out here I have a table, Table Scores First I want to join the rows on ID when the score is the same, so that in the example below ID 2 has one row. But is it also possible to remove the score column and put the score in the different year-columns as below? Thank you
  8. Hello, hope someone can help me out here I have a table, Table Scores First I want to join the rows on ID when the score is the same, so that in the example below ID 2 has one row. But is it also possible to remove the score column and put the score in the different year-columns as below? Thank you
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.