Sql pivot table

select *
from
(
  select game, player, goals
  from yourtable
) src
pivot
(
  sum(goals)
  for player in ([John], [Paul], [Mark], [Luke])
) piv
order by game

Source: stackoverflow.com

Similar codes

1 vote145 views4 answers
Psql check tables command
SQL
0 vote101 views2 answers
Denormalization in sql
SQL
2 votes143 views1 answer
How to delete view in sql
SQL
1 vote145 views1 answer
Right outer vs left outer join
SQL
0 vote157 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote180 views1 answer
000webhost database values insert
SQL
2 votes152 views6 answers
Mysql change timezone
SQL
0 vote152 views1 answer
Oracle db timestamp auto add
SQL
1 vote175 views1 answer
Drop colum oracle 18c
SQL
0 vote185 views1 answer
Liquibase update row
SQL