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 vote123 views1 answer
How to find sql server installation folder
SQL
0 vote134 views1 answer
Oracle sql date winter time
SQL
0 vote130 views1 answer
Db format in quotation
SQL
-1 vote177 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote191 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote122 views1 answer
Difference between varchar and varchar2
SQL
15 votes128 views4 answers
How to get all tables in sql
SQL
0 vote131 views1 answer
Postgres where
SQL
16 votes139 views3 answers
Jwt secret key generator laravel
SQL
11 votes124 views2 answers
Oracle all source
SQL