By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| (No column name) |
|---|
| [e],[m],[t] |
| (No column name) |
|---|
| select name, [e],[m],[t] from(select name, mark, subject from pivotEx ) f pivot( sum(mark) for subject in ([e],[m],[t])) p |
| name | e | m | t |
|---|---|---|---|
| a | 80 | null | 70 |
| b | null | null | 60 |
| c | 90 | 40 | 80 |