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

0 vote115 views1 answer
Install mysql 8 linux
SQL
3 votes123 views2 answers
Mysql time
SQL
0 vote135 views2 answers
How covert into int in maria db
SQL
3 votes117 views1 answer
Mysql UPDate with enner join
SQL
0 vote135 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote121 views1 answer
Restore backupfile discourse
SQL
0 vote121 views1 answer
Product of a column in mysql
SQL
0 vote111 views1 answer
Possgress drop if exists view
SQL
7 votes117 views3 answers
Add primary key to database sql
SQL
0 vote141 views1 answer
Cannot start database server xampp mac os
SQL